Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

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

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans