Synchronization error on LedgerPeriodModuleAccessControl after upgrading to CU12

Hello guys,

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).


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 ?

Thank you!