Hi,
I am upgrading an AX 2012 R2 CU 6 to AX 2012 R3 CU 12.
I have created a Test environment that is kind of a simple copy of production and insured that I could compile and Syncronize with no errors. Then I deleted all R2 components, upgraded the database and installed AOS, Client, Debugger and Management Utility as described in the documentation.
Hereafter I run a full kernel compilation with axbuild xppcompileall. This results in 201 Errors and 233 Warnings, which I guess is ok because this I expect to be solved during the code merge later.
Now the documentation suggest that I create a development environment to do the code upgrade, but I rather just continue in this Test environment. I open the client and start with a syncronization of the database which results in:
SQL-fejlbeskrivelse: [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).
SQL-sætning: CREATE UNIQUE INDEX I_7375LEDGERFISCALCALENDARPERIODIDX ON "DBO".LEDGERPERIODMODULEACCESSCONTROL (PARTITION,LEDGERFISCALCALENDARPERIOD)
If I look in the table LEDGERPERIODMODULEACCESSCONTROL I can see that a new index LEDGERFISCALCALENDARPERIODIDX has been created and with allow dublicates to No. There are a lot of dublicates in this field in the data. How do I proceed?
