I just upgraded our AX 2012 R3 development environment with cumulative update 12 ( CU12 ) and after compiling, synchronization fails on one table with this error :
Description de l’erreur SQL: [Microsoft][SQL Server Native Client 11.0][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘dbo.LEDGERPERIODMODULEACCESSCONTROL’ and the index name ‘I_7375LEDGERFISCALCALENDARPERIODIDX’. The duplicate key value is (5637144576, 5637144576).
Instruction SQL: CREATE UNIQUE INDEX I_7375LEDGERFISCALCALENDARPERIODIDX ON “DBO”.LEDGERPERIODMODULEACCESSCONTROL (PARTITION,LEDGERFISCALCALENDARPERIOD)
I tried deleting the records with the duplicate key values 5637144576, but synchronization still fails. But after I delete all the records in the table it works.
Finally, I compared the sys layer with the syp layer ( the update ) and I found out that the index causing the error was added in the last update.
Does anyone have a clue on how I can fix this without deleting all the records in the table ?