Error while upgrading AX 2009 HF8 to AX 2012 R3 CU9

Dynamics 365 for Finance and Operations/AX Technical Forum
1

Hi all,

I am doing upgrade from AX 2009 HF8 to AX 2012 R3 CU9. While running the checklist for Data Upgrade in AX 2012, in “Launch Data Upgrade” step I am getting the following error. Not able to figure out how to resolve it.

Error Details are as below:

"[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.DIMENSIONATTRIBUTEVALUESET’ and the

index name ‘I_3260HASHIDX’. The duplicate key value is (5637144576, )."

"Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type ‘Microsoft.Dynamics.Ax.Xpp.ErrorException’ was thrown.

at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)

at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.callReturn(Int32 rc, interpret* ip)

at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)

at Microsoft.Dynamics.Ax.Xpp.xApplication.Dbsynchronize(Int32 tableId, Boolean checkAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable)

at Dynamics.Ax.Application.Application.Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable, Boolean , Boolean , Boolean , Boolean , Boolean , Boolean , Boolean ) in Application.dbSynchronize.xpp:line 22

at Dynamics.Ax.Application.Application.Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable)

at Dynamics.Ax.Application.ReleaseUpdateSync.syncTableUpgrade(Int32 _tableId) in ReleaseUpdateSync.syncTableUpgrade.xpp:line 21

at Dynamics.Ax.Application.ReleaseUpdateBulkCopyExecute.Run() in ReleaseUpdateBulkCopyExecute.run.xpp:line 61

at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54

at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13

at BatchRun::runJobStatic(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at BatchIL.taskThreadEntry(Object threadArg)"

When I checked the table DIMENSIONATTRIBUTEVALUESET, I found out that for all the records Hash field is null and that is causing sync errors. The same error I got for DIMENSIONATTRIBUTESET, DIMENSIONATTRIBUTEVALUECOMBINATION AND DIMENSIONATTRIBUTEVALUEGROUP. All the tables have HASH field NULL.

Has anyone come across this error in Data Upgrade???

Would appreciate for quick help as I am stuck up.

Regards,

Muneeb

2

Try to run again pre-synchronize script. Try to execute

ReleaseUpdateDB::indexAllowDup(new DictIndex(tableNum(DIMENSIONATTRIBUTEVALUESET), indexNum(DIMENSIONATTRIBUTEVALUESETp, HashIdx)));

3

Thank you Nuno for your quick response.

We tried your solution but we are still getting the same error.

Regards,

Muneeb