web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
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 20

[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

I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

#3
ManoVerse Profile Picture

ManoVerse 53 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans