Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
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.

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Database Sync issue for D365 F&O

    Hi Michael

    Please mark the answer as verified to help others.

  • Michael Antony Profile Picture
    Michael Antony 314 on at
    RE: Database Sync issue for D365 F&O

    Hi Sohail,

    I do not have any customization on the IX_RETAILTRANSACTIONSALESTRANS_TRANSACTIONID Index.

    And I have included PersonnelManagement to my model.

    I have been successfully synchronize after I did a full build on my model and all the other packages that my model referenced to.

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Database Sync issue for D365 F&O

    Kindly add the reference of PersonnelManagement in your model and compile and then sync the database.

    The error is System.IO.FileNotFoundException: Could not load file or assembly 'Dynamics.AX.PersonnelManagement, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

    Do you have PersonnelManagement modeld/package in your system?

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Database Sync issue for D365 F&O

    Would you please compare this index with the Standard machine? it seems you made changes in the index.

    IX_RETAILTRANSACTIONSALESTRANS_TRANSACTIONID

  • vini_a Profile Picture
    vini_a 50 on at
    RE: Database Sync issue for D365 F&O

    HI Michael,

    For me it i need to reinstall third party model in DEV again and rebuild then   syncing to Db worked.

    Thanks

  • Michael Antony Profile Picture
    Michael Antony 314 on at
    RE: Database Sync issue for D365 F&O

    Hi vini_a, can you please explain to me what was the missing third party files?

    Because I have the same issue with you while synchronizing my database

  • Suggested answer
    vini_a Profile Picture
    vini_a 50 on at
    RE: Database Sync issue for D365 F&O

    This issue is resolved. I was missing some of files from Thrid party .

    Thank you all for your suggestions.

  • ToddB Profile Picture
    ToddB on at
    RE: Database Sync issue for D365 F&O

    Hi Vini,

    If you are still experiencing an issue with DB Sync I would recommend creating a support incident with Microsoft.

  • vini_a Profile Picture
    vini_a 50 on at
    RE: Database Sync issue for D365 F&O

    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

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: Database Sync issue for D365 F&O

    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

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans