Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Synchronize error after restoring database and reinstalling VM

(0) ShareShare
ReportReport
Posted on by 11

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

Categories:

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans