web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data upgrade from AX 2...
Finance | Project Operations, Human Resources, ...
Unanswered

Data upgrade from AX 2012 to D365FFO failes due to duplicate records.

(0) ShareShare
ReportReport
Posted on by MDeeb 98

Hi All,

am receiving the below error on two tables during data upgrade from AX 2012 , i have updated the recid of the duplicates keys but error is still persisting, what best practices shall i use when i have duplicate data during database synchronization on D365FFO

Message [DbSync: 7.0.30261.0] [Platform: 7.0.5644.35548]: Full sync did not complete successfully. Error: AggregateException:One or more errors occurred. at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll() at Microsoft.Dynamics.AX.Data.Management.ManagedSync.<SyncAll>b__21_0() at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action) at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll() at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider) at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass15_0.<RunFullTableSync>b__0() at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler) Inner exceptions: Database execution failed: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.WORKFLOWTRACKINGSTATUSTABLE' and the index name 'I_2132INSTANCENUMBERIDX'. The duplicate key value is (5637144576, 002331). The statement has been terminated. CREATE UNIQUE INDEX I_2132INSTANCENUMBERIDX ON DBO.WORKFLOWTRACKINGSTATUSTABLE(PARTITION,INSTANCENUMBER) WITH (MAXDOP = 0) ; at Microsoft.Dynamics.AX.Data.Management.DBExecute.ThrowOnSqlExecuteException(SqlException e, String commandText) at Microsoft.Dynamics.AX.Data.Management.DBExecute.ExecuteDDLWithNewTransaction(String commandText) at Microsoft.Dynamics.AX.Data.Management.DBExecute.ExecuteSqlBatch(TableSyncSqlBatch sqlBatch) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteTableModificationDdl(TableSyncSqlBatch sqlBatch) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTableViaAlterTable(AxTable newTableSchema, TableSyncSqlBatch sqlBatch, IncrementalSyncTableSchemaBuilder tableSchemaBuilder) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TryExecuteModifyTableViaAlterTable(AxTable newTableSchema, HashSet`1 ignoreIndexListCache, IncrementalSyncTableSchemaBuilder tableSchemaBuilder, Boolean isSharingOverrideTable) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTable(AxTable newTableSchema, AxTable oldTableSchema, Int32 tableId, Boolean isSharingOverrideTable) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ModifyTable(AxTable newTableSchema, Dictionary`2 oldTableSchemaDictionary) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TableSyncAction(AxTable axTable, Dictionary`2 oldTableSchemaDictionary, ConcurrentBag`1 exceptions) Database execution failed: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.NACLAIMREIMBURSEMENTDETAIL' and the index name 'I_100897PRIMIDX'. The duplicate key value is (5637144576, shc, SHC-001316, Training). Could not create constraint or index. See previous errors. The statement has been terminated. ALTER TABLE DBO.NACLAIMREIMBURSEMENTDETAIL ADD CONSTRAINT I_100897PRIMIDX PRIMARY KEY NONCLUSTERED(PARTITION,DATAAREAID,REQUESTID,CLAIMTYPE) WITH (MAXDOP = 0) ; at Microsoft.Dynamics.AX.Data.Management.DBExecute.ThrowOnSqlExecuteException(SqlException e, String commandText) at Microsoft.Dynamics.AX.Data.Management.DBExecute.ExecuteDDLWithNewTransaction(String commandText) at Microsoft.Dynamics.AX.Data.Management.DBExecute.ExecuteSqlBatch(TableSyncSqlBatch sqlBatch) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteTableModificationDdl(TableSyncSqlBatch sqlBatch) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTableViaAlterTable(AxTable newTableSchema, TableSyncSqlBatch sqlBatch, IncrementalSyncTableSchemaBuilder tableSchemaBuilder) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TryExecuteModifyTableViaAlterTable(AxTable newTableSchema, HashSet`1 ignoreIndexListCache, IncrementalSyncTableSchemaBuilder tableSchemaBuilder, Boolean isSharingOverrideTable) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTable(AxTable newTableSchema, AxTable oldTableSchema, Int32 tableId, Boolean isSharingOverrideTable) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ModifyTable(AxTable newTableSchema, Dictionary`2 oldTableSchemaDictionary) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TableSyncAction(AxTable axTable, Dictionary`2 oldTableSchemaDictionary, ConcurrentBag`1 exceptions) Database execution failed: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.HCMGOALHEADING' and the index name 'I_4522HEADINGIDX'. The duplicate key value is (5637144576, Active participation in MIC meetings, including timeliness and accuracy of reports submitted to the MIC ). The statement has been terminated. CREATE UNIQUE INDEX I_4522HEADINGIDX ON DBO.HCMGOALHEADING(PARTITION,GOALHEADINGID) WITH (MAXDOP = 0) ; at Microsoft.Dynamics.AX.Data.Management.DBExecute.ThrowOnSqlExecuteException(SqlException e, String commandText) at Microsoft.Dynamics.AX.Data.Management.DBExecute.ExecuteDDLWithNewTransaction(String commandText) at Microsoft.Dynamics.AX.Data.Management.DBExecute.ExecuteSqlBatch(TableSyncSqlBatch sqlBatch) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteTableModificationDdl(TableSyncSqlBatch sqlBatch) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTableViaAlterTable(AxTable newTableSchema, TableSyncSqlBatch sqlBatch, IncrementalSyncTableSchemaBuilder tableSchemaBuilder) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TryExecuteModifyTableViaAlterTable(AxTable newTableSchema, HashSet`1 ignoreIndexListCache, IncrementalSyncTableSchemaBuilder tableSchemaBuilder, Boolean isSharingOverrideTable) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTable(AxTable newTableSchema, AxTable oldTableSchema, Int32 tableId, Boolean isSharingOverrideTable) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ModifyTable(AxTable newTableSchema, Dictionary`2 oldTableSchemaDictionary) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TableSyncAction(AxTable axTable, Dictionary`2 oldTableSchemaDictionary, ConcurrentBag`1 exceptions).
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,854 Super User 2026 Season 2 on at

    Hi Mohammad,

    The issue is not with record IDs but with the index fields mentioned in the error. The record ID reported was the key to find the duplicate record by Record ID. You need to check which fields are used in the indexes which do report errors. Then decide to fix data or check if it makes sense to allow duplicate records on this particular index.

  • MDeeb Profile Picture
    MDeeb 98 on at

    Thank you Andre, i added indexes and keys on the tables that had duplicate and the synch still failed,i had to delete the records until the synch was successfull, then it failed on step 9 postSync for data upgrade with below error :

    + System

     - Provider

      [ Name]  Microsoft-Dynamics-AX-DatabaseSynchronize

      [ Guid]  {54CFBDB4-DE37-4F30-B7FC-B7AC357DA6AD}

      EventID 57

      Version 0

      Level 2

      Task 33

      Opcode 0

      Keywords 0x4000000000000006

     - TimeCreated

      [ SystemTime]  2020-12-04T23:42:43.549193000Z

      EventRecordID 409404

     - Correlation

      [ ActivityID]  {B9251592-C727-0002-BB3A-2FB927C7D601}

     - Execution

      [ ProcessID]  12120

      [ ThreadID]  9768

      Channel Microsoft-Dynamics-AX-DatabaseSynchronize/Operational

      Computer build5dd3f13b-1

     - Security

      [ UserID]  S-1-5-21-1153473219-3585346769-2562767616-500

    - EventData

     Message [DbSync: 7.0.30261.0] [Platform: 7.0.5644.35548]: Custom action threw exception(s), please investigate before synchronizing again: 'ErrorException: at Dynamics.AX.Application.UpgradeServiceHelper.`waitForUpgrade(UpgradeServiceContract _upgradeService, ReleaseUpdateLogManager _logManager, Int32 _maxIterations) in xppSource://Source/ApplicationFoundation\AxClass_UpgradeServiceHelper.xpp:line 174 at Dynamics.AX.Application.UpgradeServiceHelper.waitForUpgrade(UpgradeServiceContract _upgradeService, ReleaseUpdateLogManager _logManager, Int32 _maxIterations) at Dynamics.AX.Application.UpgradeServiceHelper.`WaitForDataUpgradeToComplete() in xppSource://Source/ApplicationFoundation\AxClass_UpgradeServiceHelper.xpp:line 140 at Dynamics.AX.Application.UpgradeServiceHelper.WaitForDataUpgradeToComplete() at UpgradeServiceHelper::WaitForDataUpgradeToComplete(Object[] , Boolean& ) at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters) at Microsoft.Dynamics.AX.Deployment.Setup.AppOperations.RunStaticXppMethod(String className, String methodName, String methodInput, String partitionName) at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass29_0.<NOTE_LeavingSynchronizer_CallStackAboveThisLineIsCustomCode>b__0() at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)'

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,854 Super User 2026 Season 2 on at

    Hi Mohammad,

    I'm not sure what is the cause of this error. Have you checked if the build of the custom models was successful?

  • MDeeb Profile Picture
    MDeeb 98 on at

    Thank you Andre, is it possible the VM is a build one and not a dev?

    shall i reconfigure new one using Dev architecture and try ?

    Thank you,

  • Microsoft Dynamics Community Profile Picture
    Microsoft Dynamics ... 5 on at

    Hi Mohammad ,

    You resolved this error? We are facing same issue at step 9...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 341 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 312

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 262 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans