web
You’re offline. This is a read only version of the page.
close
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 61,005 Super User 2025 Season 2
 
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
I have the same question (0)
  • Suggested answer
    Dr Gomathi MVP, MCT Community lead, MLE Profile Picture
    Dr Gomathi MVP, MCT... 395 Super User 2025 Season 2 on at

    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! 

  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

    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
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 1,276 on at
    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 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans