Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Database sync failed
Finance | Project Operations, Human Resources, ...
Suggested answer

Database sync failed

(0) ShareShare
ReportReport
Posted on by Sheikh Sohail 6,125

Hi Experts

I am getting the below error while performing the database sync. I already performed full build multiple times.

Application version 10.0.21

AOS database sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: ArgumentNullException:Value cannot be null.
Parameter name: metadata
at Microsoft.Dynamics.Ax.Xpp.Utilities.ParameterHelper.Ensure(String parameterName, Object parameterValue)
at Microsoft.Dynamics.AX.Data.Management.View.ViewQueryNode..ctor(Int32 dataset, AxQuerySimple metadata)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.GetViewQueryNode(Int32 viewId, Boolean isDataEntityView)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.PopulateViewList(Int32 viewId)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.SortSyncRequest(IEnumerable`1 requests)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.SyncAll(IProducerConsumerCollection`1 modifiedViewDependencies)
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).
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunFullTableSync>b__20_1(Tuple`2 result)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider)
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
Database synchronization completed (160920 ms). Errors found.
AOS database sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: ArgumentNullException:Value cannot be null.
Parameter name: metadata
at Microsoft.Dynamics.Ax.Xpp.Utilities.ParameterHelper.Ensure(String parameterName, Object parameterValue)
at Microsoft.Dynamics.AX.Data.Management.View.ViewQueryNode..ctor(Int32 dataset, AxQuerySimple metadata)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.GetViewQueryNode(Int32 viewId, Boolean isDataEntityView)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.PopulateViewList(Int32 viewId)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.SortSyncRequest(IEnumerable`1 requests)
at Microsoft.Dynamics.AX.Data.Management.View.ManagedSyncViewWorker.SyncAll(IProducerConsumerCollection`1 modifiedViewDependencies)
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).
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunFullTableSync>b__20_1(Tuple`2 result)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider)
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
syncengine.exe exited with code -1.

Categories:
Development / Customization / SDK
Other
Administration and Setup
  • Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Database sync failed

    Hey, Andre

    It was related to PU-45, So Microsoft suggested to re-allocate the VM.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,860 Test role Public on at
    RE: Database sync failed

    It is hard to say if it is related to your customization or if it is another rare occurring bug. Do you have customizations on views or data entities?

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Database sync failed

    Hi Judy

    Thank you for your reply.

    Yes, I am the administrator of the environment.

    "ManagedSyncViewWorker" this object does not exist anywhere.

  • huijij Profile Picture
    huijij 19,801 on at
    RE: Database sync failed

    Hi Sohail,

    Have you try to fix it with admin role?

    Please try to do a full build of the 'ManagedSyncViewWorker'  as suggested in the error message.

  • Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Database sync failed

    Hi Andre

    Yes, We have some customization, not ISV, but these are the minimum customization like field addition in extension tables or custom tables.

    More importantly, I already tried to redeploy the package after removing my customization.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,860 Test role Public on at
    RE: Database sync failed

    Hi Sohail,

    Is this a standard environment or do you have customizations? Did the full build complete without errors? When was it working the last time without this issue and what got changed? Did you apply the 10.0.21 update or was there a change in the application (customization, ISV)?

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

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Jahanvi Profile Picture

Jahanvi 34

#2
PJ JohnPaul Profile Picture

PJ JohnPaul 5

#3
SudhanshuMSID Profile Picture

SudhanshuMSID 1

Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans