Dynamics Community Forum Thread Details

Hello guys,

I'm hit to some strange error during Synchronize DB, while Build actually no error, but there are bunch of error with no reference of object / line which suggested to be Synchronize issue.

Like below :

Severity Code Description Project File Line Suppression State
Error at Microsoft.Dynamics.AX.Data.Management.Delta.DeltaModifyField.AreFieldsOfSameType(AxTableField newField, AxTableField oldField, Action`2 logger, Boolean throwOnMismatch) 0
Error at Microsoft.Dynamics.AX.Data.Management.IncrementalSyncTableSchemaBuilder.CompareFieldModify() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ModifyTable(AxTable newTableSchema, Dictionary`2 oldTableSchemaDictionary, IProducerConsumerCollection`1 modifiedViewDependencies, HashSet`1 optionalIndexes) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll() 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll() 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.<SyncAll>b__21_0() 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync() 0
Error InvalidOperationException:Table 'MyTableStaging': Converting Field 'ExpiryDate' of Type 'AxTableFieldUtcDateTime' to 'AxTableFieldDate' is not supported. Please drop the original field, sync the table and add a new field with the same name if needed. 0
Error Managed Sync Table Worker encountered an exception, but is continuing because ContinueOnError is true. Table Sync Failed for Table: MyTableStaging. Exception: System.InvalidOperationException: Table 'MyTableStaging': Converting Field 'ExpiryDate' of Type 'AxTableFieldUtcDateTime' to 'AxTableFieldDate' is not supported. Please drop the original field, sync the table and add a new field with the same name if needed. 0
Error at Microsoft.Dynamics.AX.Data.Management.IncrementalSyncTableSchemaBuilder.CompareTableSchema() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TableSyncAction(AxTable axTable, Dictionary`2 oldTableSchemaDictionary, ConcurrentBag`1 exceptions, IProducerConsumerCollection`1 modifiedViewDependencies). 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.ExecuteModifyTable(AxTable newTableSchema, AxTable oldTableSchema, Int32 tableId, Boolean isSharingOverrideTable, HashSet`1 optionalIndexes) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action) 0
Error Inner exceptions: 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass21_0.<RunFullTableSync>b__0() 0
Error AOS database sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: AggregateException:One or more errors occurred. 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunFullTableSync>b__21_1(Tuple`2 result) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync() 0
Error at Microsoft.Dynamics.AX.Data.Management.IncrementalSyncTableSchemaBuilder.CompareField() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.TableSyncAction(AxTable axTable, Dictionary`2 oldTableSchemaDictionary, ConcurrentBag`1 exceptions, IProducerConsumerCollection`1 modifiedViewDependencies) 0
Error syncengine.exe exited with code -1. 1

Worth to mentioned also, what I put in bold, it is my custom table which has field type change, but seems always failed to synchronize, although I already follow the instruction to drop the field - synchronize - and add again.

Another thing also, this error only happened in my Build server when there is no data inside its SQL DB, while in our local DevBox, there is no issue even when the table which faulted has data.

I am not sure whether the rest of the error is related or cause by the field mistake on my table or not, but currently I'm a bit lost on what to do.

Thanks,