Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

LCS on-prem service update (10.0.22 - 10.0.30) DBSync failed

(0) ShareShare
ReportReport
Posted on by

[DbSync: 7.0.30566.0] [Platform: 7.0.6592.94] [SourcePlatform: 7.0.6592.94]: Full sync did not complete successfully. Error: AggregateException:One or more errors occurred. at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll() at Microsoft.Dynamics.AX.Data.Management.ManagedSync.<SyncAll>b__21_0() at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action) at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll() at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider) at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass20_0.<RunFullTableSync>b__0() at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler) Inner exceptions: InvalidOperationException:Unable to locate data source node on view field 'ParentPosition' with data source 'HcmPositionHierarchyLine'. at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGeneratorForDataEntity`1.GetDataSourceAndTable(IDataFieldBound viewFieldBound) at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGeneratorForView.AddBoundViewFieldsToSelectionList(IEnumerable`1 selectedFieldList, IDictionary`2 dataSourcesWithFields, Stack`1 nullFieldStack) at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGeneratorForDataEntity`1.AddFieldsToSelectionList(IEnumerable`1 selectedFieldList, IDictionary`2 dataSourcesWithFields, Stack`1 nullFieldList) at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGeneratorForSync`1.VisitSelectionFieldList(GenerateContext payload, SelectionFieldList selectionFieldList) at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGenerator.<>c__DisplayClass31_0.<VisitSelectQuery>b__0() in D:\dbs\sh\l23t\1116_211234\cmd\1\Source\Kernel\xppil\XppSupport\DataAccess\SqlStatementGenerator.cs:line 201 at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGenerator.LogAndExecute(GenerateContext payload, Func`1 func, String methodName) in D:\dbs\sh\l23t\1116_211234\cmd\1\Source\Kernel\xppil\XppSupport\DataAccess\SqlStatementGenerator.cs:line 1560 at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGenerator.VisitSelectQuery(GenerateContext payload, SelectQuery selectQuery) in D:\dbs\sh\l23t\1116_211234\cmd\1\Source\Kernel\xppil\XppSupport\DataAccess\SqlStatementGenerator.cs:line 276 at Microsoft.Dynamics.AX.DataAccess.SqlStatementGenerator.SqlStatementGeneratorForSync`1.VisitSelectQuery(GenerateContext payload, SelectQuery selectQuery) at Microsoft.Dynamics.AX.Data.Management.ManagedSyncDDLBuilder`1.GenerateStatement(T syncObject, Func`2 selectQueryGenerator) at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.SyncAllAction[T](ViewSyncGraphNode viewToSync, Dictionary`2 oldViewDefinitions, StringCollection dataEntityViewList, StringCollection compositeEntityViewList, IProducerConsumerCollection`1 modifiedViewDependencies) at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.DoSyncAll[T](IEnumerable`1 sortedViewList, Dictionary`2 oldViewDefinitions, IProducerConsumerCollection`1 modifiedViewDependencies).

pastedimage1670502090170v1.png

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

Overall leaderboard

Product updates

Dynamics 365 release plans