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 / Small and medium business | Business Central, N... / Sync-NAVTenant error w...
Small and medium business | Business Central, N...
Suggested answer

Sync-NAVTenant error with ID 5151

(2) ShareShare
ReportReport
Posted on by Mohana Yadav 60,199 Super User 2025 Season 1
 
We are upgrading one of our customer from BC14 to BC21/25 and getting this error while synchronizing the tenant. 
Did anyone face this issue?
 
We verified that 5151 table has same field names.
 
 
Microsoft.Dynamics.Nav.Management\Sync-NAVTenant : Changes to the tenant database could not be applied. Affected tables will not be available.

The first error was:

The tenant upgrade step to preserve integration IDs has failed because the integration records table with the ID 5151 does not have the following fields (with exact naming): Integration ID, Record ID, Table ID, Modified On. The integration records table ID is specified by the Integration Records Table configuration setting of the server instance.

Retry the operation when the problem has been resolved.
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central migration
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 349 on at
    Sync-NAVTenant error with ID 5151
    Hii there,
    as per Microsoft 
     
    The following table lists the Business Central 14 versions and the minimum version of later releases that are compatible for upgrade. For example, you can upgrade version 14.0 to any 15 or 16 version. You can only upgrade version 14.11 to version 15.5 (or later).
     
    So check compatibility matrix before upgrading..
     
     
    If you found answer please make it answered .
    Thank you.
    Kamal Khakhkhar 
  • gdrenteria Profile Picture
    gdrenteria 15,570 Most Valuable Professional on at
    Sync-NAVTenant error with ID 5151

    Hi, good day
    I hope this can help you, and give you some hints.

    Some Known Issues in Business Central On-premises - Business Central | Microsoft Learn

    Best Regards
    Gerardo

  • Suggested answer
    Dr Gomathi MVP, MCT Community lead, MLE Profile Picture
    Dr Gomathi MVP, MCT... 254 on at
    Sync-NAVTenant error with ID 5151

    The error occurs because the Integration Records Table (ID 5151) is missing required fields (Integration ID, Record ID, Table ID, and Modified On) during the tenant synchronization process. First, verify that Table 5151 in BC14 and BC21/25 has the same schema using INFORMATION_SCHEMA.COLUMNS in SQL. Next, check if the Integration Records Table configuration correctly points to Table 5151 by running Get-NAVServerConfiguration -ServerInstance <InstanceName> | Select-Object IntegrationRecordsTable. If the table structure is correct, try forcing synchronization with Sync-NAVTenant -ServerInstance <InstanceName> -Mode Force or -Mode Clean. If extensions modify Table 5151, verify them using Get-NAVAppInfo and reinstall if necessary. If required fields are missing, you can manually add them via AL code or SQL. Restart the Business Central service instance using Restart-NAVServerInstance -ServerInstance <InstanceName>, then retry synchronization. Ensuring the correct schema, configuration, and extension compatibility should resolve the issue. Let me know if you need further 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans