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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / DB Synch fails during ...
Finance | Project Operations, Human Resources, ...
Unanswered

DB Synch fails during data upgrade from AX2012 at step 3

(0) ShareShare
ReportReport
Posted on by CarloT

Hello,

I'm attempting to run the data upgrade on a VM machine 10.0.32 version.

I copied the SQL database from AX2012R3 with customizations.

I keep getting this error when I run the upgrade script or when I run the db syncronization from Visual Studio

Log level - Error | 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, Boolean isParallelSync)
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)
Failed operation step '/DataUpgrade/DbSync/SyncSchema'
Process 'C:\AosService\PackagesLocalDirectory\bin\SyncEngine.exe' failed with exit code -1; see error logs for details.
at Microsoft.Dynamics.Servicing.DataUpgrade.Operations.Operation.RunProcess(String fileName, ArgumentsBuilder args)
at Microsoft.Dynamics.Servicing.DataUpgrade.Operations.OperationStep.Execute()

I've tried everything I can think of. 

is there a way to debug the db synch process to see where the actual failure is happening?

  • Anton Venter Profile Picture
    Anton Venter 21,302 Super User 2026 Season 2 on at

    Hi Carlo,

    Can you find a log file of the database sync? Perhaps in C:\AosService\PackagesLocalDirectory\bin\. Or have you looked in the Windows event viewer if there are any errors from SQL Server?

  • CarloT Profile Picture
    CarloT on at

    Hello Anton, thank you for your reply.

    I checked the event viewer and it seems to give the same kind of info:

    Message">[DbSync: 7.0.30584.0] [Platform: 7.0.6801.37] [SourcePlatform: 7.0.6801.37]: 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, Boolean isParallelSync) 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).</

    I'm thinking there is a problem with a View maybe?

  • CarloT Profile Picture
    CarloT on at

    I found this also in the event viewer:

    [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.SYSGLOBALCONFIGURATION' with unique index 'I_65472NAMEIDX'. The duplicate key value is*

     callStack at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.Interop.GetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* , Boolean truncateStackTrace) at [aoskernel.dll]Microsoft.Dynamics.Ax.Services.AOSAppDomainHelper.callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* ) at callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* ) at gopts(Int32 , Char** ) at gopts(Int32 , Char** ) at [aoskernel.dll]Microsoft.Dynamics.AX.AOS.StartupInternal(String[] Arguments) at [aoskernel.dll]Microsoft.Dynamics.AX.AOS.Startup() at Microsoft.Dynamics.AX.AosConfig.?A0x8043b1c4.GetAosConfig() at Microsoft.Dynamics.AX.AosConfig.?A0x8043b1c4.GetAosConfig() at [Microsoft.Dynamics.AX.AosConfig.dll]Microsoft.Dynamics.AX.AosConfig.Config.InitInternal() at [Microsoft.Dynamics.AX.AosConfig.dll]Microsoft.Dynamics.AX.AosConfig.Config.InitOnce(Boolean isOfflineMode) at [Microsoft.Dynamics.AX.Framework.Database.dll]Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.StartAosCode(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider) at [Microsoft.Dynamics.AX.Framework.Database.dll]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.dll]Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider) at [Microsoft.Dynamics.AX.Framework.Database.dll]Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync() at [Microsoft.Dynamics.AX.Framework.Database.dll]Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync() at [Microsoft.Dynamics.AX.Framework.Database.dll]Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync() at [Microsoft.Dynamics.AX.Framework.Database.dll]Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options) at [SyncEngine.exe]Microsoft.Dynamics.AX.Framework.Database.SyncEngineMain.Sync(Parameters parameters) at [SyncEngine.exe]Microsoft.Dynamics.AX.Framework.Database.SyncEngineMain.Main(String[] args)

     statement INSERT INTO SYSGLOBALCONFIGURATION (NAME,VALUE,SERVERID,SETTINGLEVEL,RECVERSION,RECID) VALUES (?,?,?,?,?,?)

  • CarloT Profile Picture
    CarloT on at

    And this error

    Initialization of Session performance counters failed. exception: The requested Performance Counter is not a custom counter, it has to be initialized as ReadOnly.

  • Anton Venter Profile Picture
    Anton Venter 21,302 Super User 2026 Season 2 on at

    Hi Carlo,

    Since dbo.SYSGLOBALCONFIGURATION is a system table, perhaps Microsoft support can assist you with this?

  • CarloT Profile Picture
    CarloT on at

    I don't think the SYSGLOBALCONFIGURATION error is the problem.

    I think one of the customized views or query has invalid data but the error is very unhelpful.

    Any other suggestions where to look for error logs?

    Thank you.

  • Anton Venter Profile Picture
    Anton Venter 21,302 Super User 2026 Season 2 on at

    What is the status of the database upgrade? What do you get if you execute this query? It's from this article: Monitoring the data upgrade.

    SELECT StartTime, EndTime, Steps, SubSteps, Status
FROM [DBUPGRADE].[DATAUPGRADESTATUS]
ORDER BY EndTime DESC

    Have you checked the runbook logs? Located in a sub-folder under the deployable package.

    There is also some log information about pre and post sync available here:

    select * from RELEASEUPDATESCRIPTSERRORLOG

  • Carlo T Profile Picture
    Carlo T 30 on at

    Hi Anton,

    I finally found the cause. 

    It was bad xml from the upgrade tool.

    There were a few views that had no fields from AX.

    I removed those files and the synch completed successfully. 

    The error was not helpful enough.

    I used this XPath expression to parse all our files and to find the bad ones after I understood what to look for.

    //AxView/Fields[not(AxViewField)]

    Thank you for your help.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 320 Super User 2026 Season 2

#3
CU-1234529-002 Profile Picture

CU-1234529-002 210

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans