Tuesday, June 19, 2018

Synchronization error on LedgerPeriodModuleAccessControl after upgrading to CU12

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)