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, ... / Database Sync issue fo...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Database Sync issue for D365 F&O

(0) ShareShare
ReportReport
Posted on by vini_a 50

HI All,

we trying to build our DEv machine on cloud based Environment. currently we are able to get latest code and Database from  existing  DEV database and build models  successfully.  issue currently having with Database sync .we getting following errors any ideas?

DbSync: 7.0.30305.0] [Platform: 7.0.5816.35651]: WideIndexesValidator: Table 'RETAILTRANSACTIONSALESTRANS' has index 'IX_RETAILTRANSACTIONSALESTRANS_TRANSACTIONID' with a high number of columns: 48
Microsoft.Dynamics.AX.InitializationException: Failed to initialize OCC
at Microsoft.Dynamics.AX.AOS.StartupInternal(String[] Arguments)
at Microsoft.Dynamics.AX.AOS.Startup()
at Microsoft.Dynamics.AX.AOS.StartupInternal(String[] Arguments)
at Microsoft.Dynamics.AX.AosConfig.?A0xc9ba6805.GetAosConfig()
at Microsoft.Dynamics.AX.AOS.Startup()
at Microsoft.Dynamics.AX.AosConfig.?A0xc9ba6805.GetAosConfig()
at Microsoft.Dynamics.AX.AosConfig.Config.InitInternal()
at Microsoft.Dynamics.AX.AosConfig.Config.InitOnce(Boolean isOfflineMode)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.StartAosCode(SyncOptions syncOptions, String sqlConnectionString)
at Microsoft.Dynamics.AX.AosConfig.Config.InitInternal()
at Microsoft.Dynamics.AX.AosConfig.Config.InitOnce(Boolean isOfflineMode)
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.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)
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
Database synchronization completed (66414 ms). Errors found.
Microsoft.Dynamics.AX.InitializationException: Failed to initialize OCC
at Microsoft.Dynamics.AX.AOS.StartupInternal(String[] Arguments)
at Microsoft.Dynamics.AX.AOS.Startup()
at Microsoft.Dynamics.AX.AosConfig.?A0xc9ba6805.GetAosConfig()
at Microsoft.Dynamics.AX.AosConfig.Config.InitInternal()
at Microsoft.Dynamics.AX.AosConfig.Config.InitOnce(Boolean isOfflineMode)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.StartAosCode(SyncOptions syncOptions, String sqlConnectionString)
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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,259 Super User 2026 Season 2 on at

    Hi Vini,

    The first line of the error message tells you something about an index on table RETAILTRANSACTIONSALESTRANS. Can you verify the details about this index on this table in your environment? Is there a change on the standard indexes of this table?

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,099 on at

    Hi Vini_a,

    Could you, please, also share the PU version you are using?

  • vini_a Profile Picture
    vini_a 50 on at

    HI Sergei

    Currently we have following PU version.

    Application release Microsoft Dynamics 365 for Finance and Operations (10.0.15)
    Platform release Update39 (7.0.5816.35651)
  • vini_a Profile Picture
    vini_a 50 on at

    HI André Arnaud de Calavon

    there is no change on standard indexes of this table. we just trying  Copy doen our old DEv database to new DEV database (Cloud hosted)

    Thanks

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,099 on at

    Hi Vini_a,

    Do you have the same version in old dev? Is it also could-hosted?

  • vini_a Profile Picture
    vini_a 50 on at

    HI

    yeah we have same version on old DEV. but it is not cloud hosted. it Microsoft managed Sandbox.

    FYI old DEV machine

    Application release Microsoft Dynamics 365 for Finance and Operations (10.0.15)

    Platform release Update39 (7.0.5816.35651)

    View detailed version information

    Thanks,

    Vini

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,099 on at

    Hi Vini,

    Did you follow instructions from docs.microsoft.com/.../dbmovement-scenario-exportuat to copy data from sandbox to dev?

  • vini_a Profile Picture
    vini_a 50 on at

    yeah we used the same steps. and  still not able sync database  and in eventlog I see some this errors

    IN AX-Application folder log

    Unable to perform data synchronization. The data store with record Id 68719496237 does not exist in the system

    IN regular applicationlog

    Metadata service communication retry attempts failed to resolve issues with the following settings AX7CertificateUserName: FRServiceUser@dynamics.com; AX7CertificateThumbprint: E6E418396A4DC4EFC5F3CEA72EA96148C39714B0; AX7FederationRealm: spn:00000015-0000-0000-c000-000000000000; AX7ProviderName: mintedtoken.dynamics.com; AX7TokenIssuer: fakeacs.accesscontrol.windows.net/

    Component: Microsoft.Dynamics.Integration.Common.TraceLog

    User: NT AUTHORITY\NETWORK SERVICE

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,099 on at

    Hi Vini,

    Are cloud-hosted and MS managed environment are in the same LCS project? If not, have you tried running the admin user provision tool to change the admin account on the new DB?

    docs.microsoft.com/.../access-instances

  • vini_a Profile Picture
    vini_a 50 on at

    HI Sergei,

    I just tried Provisioning the administrator user and try to sync again. still getting same error. not sure if I need to perform any other steps.

    Thanks

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 August 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 495 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
CU10121822-0 Profile Picture

CU10121822-0 366

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