Dynamics Community Forum Thread Details

Table failed to sync

Hi,

When I tried to sync the database, I got the error

>>>>>>>>>>>><<<<<<<<<<<<<

"Table Sync Failed for Table: TRXInventTransStaging. Exception: System.InvalidOperationException: Sequence contains no matching element

at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)

at Microsoft.Dynamics.AX.Data.Management.IncrementalSyncTableSchemaBuilder.HandleSystemFieldsProperty(AxTable newTable, AxTable oldTable, IList`1 addFields, IList`1 dropFields, IList`1 modifyFields, Int32 tableId)

at Microsoft.Dynamics.AX.Data.Management.IncrementalSyncTableSchemaBuilder.CompareField()

at Microsoft.Dynamics.AX.Data.Management.IncrementalSyncTableSchemaBuilder.CompareTableSchema()

at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTable(AxTable newTableSchema, AxTable oldTableSchema, Int32 tableId)

at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ModifyTable(AxTable newTableSchema, Dictionary`2 oldTableSchemaDictionary)

at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.SyncIncremental(IList`1 requests, IList`1 dropEntities)

AOS database sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: AOS database sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Incremental sync did not complete successfully. Error: AggregateException:One or more errors occurred.

Inner exceptions:

InvalidOperationException:Sequence contains no matching element.

at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunPartialTableSync>b__18_1(Tuple`2 result)

at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)

at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunPartialTableSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider)

at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.PartialTableViewSync()

at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.PartialSync()

at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync()

at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)

Process: syncengine.exe exited with code -1.

Database synchronization failed. You may have to do a full build of the package 'TRX' and all of its dependent packages.

Validation step: Database synchronization completed (73487 ms).

Validation completed (73493 ms).

>>>>>>>>>>>>><<<<<<<<<<<<<

Thanks,

Quick Links

Leaderboard