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,
