Hello,
One of my colleagues broked her VM. Initially the synchronization never finished without errors. After trying different solution to fix it, our IT said that a new VM has to be reinstalled. So as we did. But after reinstalling and restoring the DB, mapping the workspaces, etc. we are still facing issues when syncing. We tried full build with package reference, sync again, and again, but without success. We saw that most of the errors are based on entities. Below you have the errors that we have. Any help will be highly appreciated.
Severity Code Description Project File Line Suppression State
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.Xpp.RelationHelper.GetLinkFromFieldHelper(String thisTableName, String fieldName, Int32 relatedTableId, Int32 thisTableId) 0
Error at Dynamics.AX.Application.EmbeddedQueryBuildDataSourceImplementation.InitializeRelationsFromMetadata(AxQuerySimpleDataSource axDataSource, QueryDataSourceResolver resolver) 0
Error Unable to construct xpp Query object for Data Entity View: RenTemplateEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'InventInventoryTagCountingJournalNameEntity(9404)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Unable to construct xpp Query object for Data Entity View: OrderClassCreditLimitEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'QuotationApprovalStatusSetupEntity(16889)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Unable to construct xpp Query object for Data Entity View: SvcContractTypeEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.SyncAllAction[T](ViewSyncGraphNode viewToSync, Dictionary`2 oldViewDefinitions, StringCollection dataEntityViewList, StringCollection compositeEntityViewList) 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'InventInventoryAdjustmentJournalNameEntity(1897)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Dynamics.AX.Application.QueryBuilder.NewQueryFromAxQuery(AxQuery axQuery, Boolean generateOnlyForView) 0
Error Unable to construct xpp Query object for Data Entity View: InventInventoryMovementJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Dynamics.AX.Application.Query..ctor(Object _source) 0
Error Inner exceptions: 0
Error Unable to construct xpp Query object for Data Entity View: InventInventoryAdjustmentJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Unable to construct xpp Query object for Data Entity View: InventInventoryTransferJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'AssetInventoryFixedAssetTransferJournalNameEntity(2058)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunFullTableSync>b__15_1(Tuple`2 result) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncDataEntityViewDDLBuilder.GenerateSelectQueryFromSyncObject(AxDataEntityView dataEntityView) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll() 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync(SyncOptions options) 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'BOMBillOfMaterialsJournalNameEntity(10783)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Microsoft.Dynamics.Ax.Xpp.RelationHelper.GetLinkFromField(String tableName, String fieldName, Boolean allRelations) 0
Error Unable to construct xpp Query object for Data Entity View: PurchParametersEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'InventInventoryCountingJournalNameEntity(7898)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Unable to construct xpp Query object for Data Entity View: QuotationApprovalStatusSetupEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 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.Framework.Database.Tools.SyncEngine.FullSync() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action) 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'PurchParametersEntity(18546)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'InventInventoryMovementJournalNameEntity(3547)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error NullReferenceException:Object reference not set to an instance of an object. 0
Error at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.DoSyncAll[T](IEnumerable`1 sortedViewList, Dictionary`2 oldViewDefinitions). 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncDDLBuilder`1.GenerateStatement(T syncObject, Func`2 selectQueryGenerator) 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'SvcContractTypeEntity(17714)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Unable to construct xpp Query object for Data Entity View: ProjInventoryProjectConsumptionJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'ProjInventoryProjectConsumptionJournalNameEntity(12785)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Dynamics.AX.Application.EmbeddedQueryBuildDataSourceImplementation.AddLinksForUseRelations() 0
Error Unable to construct xpp Query object for Data Entity View: InventInventoryCountingJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'InventInventoryTransferJournalNameEntity(5751)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 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__DisplayClass15_0.<RunFullTableSync>b__0() 0
Error Unable to construct xpp Query object for Data Entity View: AssetInventoryFixedAssetTransferJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'DimensionAttributeOrderClassSetupEntity(19617)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'RenTemplateEntity(18020)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Microsoft.Dynamics.Ax.Xpp.RelationHelper.GetLinkBetweenTwoTables(String thisTableName, String relatedTableName, Boolean& validateRef, IRecord relatedRecord, TableScope scope, Boolean skipLinkSwap, Boolean addSelfRelationIfNotFound, Boolean honorGenericRelatioshipFirst) 0
Error Unable to construct xpp Query object for Data Entity View: InventInventoryTagCountingJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 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.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options) 0
Error at Dynamics.AX.Application.QueryImplementation.CreateImplementation(Query parent, Object _source) 0
Error at Dynamics.AX.Application.ManagedQueryImplementation.NewQueryFromObject(Query newQuery, Object source) 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'RenParametersEntity(18871)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Dynamics.AX.Application.QueryBuilder.NewQueryFromAxQuerySimple(Query query, AxQuerySimple axQuery) 0
Error Unable to construct xpp Query object for Data Entity View: RenParametersEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'OrderClassCreditLimitEntity(17207)' Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error at Microsoft.Dynamics.Ax.Xpp.RelationHelper.GetLinkToRelatedTable(String thisTableName, String relatedTableName, IRecord relatedRecord, Boolean& validateRef, TableScope scope, Boolean ignoreTableRelations, Boolean addSelfRelationIfNotFound, Boolean honorGenericRelatioshipFirst) 0
Error at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.DoSyncAll[T](IEnumerable`1 sortedViewList, Dictionary`2 oldViewDefinitions) 0
Error Unable to construct xpp Query object for Data Entity View: DimensionAttributeOrderClassSetupEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error Unable to construct xpp Query object for Data Entity View: BOMBillOfMaterialsJournalNameEntity Ax Query: Metadata Exception: System.NullReferenceException: Object reference not set to an instance of an object. 0
Error syncengine.exe exited with code -1. 1