Skip to main content

Notifications

Announcements

No record found.

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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 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