web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Sync-NAVApp error The table 'Exchange Contact' cannot be located BC21

(0) ShareShare
ReportReport
Posted on by 9

Upgrade BC13 to BC21 error when synchronizing the BC21 Base application.

1 step getting the database to BC14 went smooth but from BC14 to BC21 I get then below error when synchronizing the Base Application app.

I have looked and the tables it tries to remove is in all versions so why am I getting this error ?

this is the command i run

Sync-NAVApp -ServerInstance $NewBcServerInstance  -Name "Base Application" -Version "21.0.46256.46853"

and if i run the get-navappinfo it does list that extension as published.

 

Any suggestions ??.

 

Sync-NAVApp : Table 6701 Exchange Contact :: The table 'Exchange Contact' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

Table 6703 Booking Service :: The table 'Booking Service' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

Table 6704 Booking Mailbox :: The table 'Booking Mailbox' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

Table 6705 Booking Staff :: The table 'Booking Staff' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

Table 6707 Booking Item :: The table 'Booking Item' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

At line:1 char:1

+ Sync-NAVApp -ServerInstance $NewBcServerInstance  -Name "Base Applica ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : InvalidOperation: (:) [Sync-NAVApp], InvalidOperationException

    + FullyQualifiedErrorId : MicrosoftDynamicsNavServer$AA_BC21/nav-systemapplication,Microsoft.Dynamics.Nav.Apps.Management.Cmdlets.SyncNavApp

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    on at
    RE: Sync-NAVApp error The table 'Exchange Contact' cannot be located BC21

    Hello,

    Best probably is to raise this question to Microsoft via your partner or CSP.

    Thank you.

  • Suggested answer
    S_Reist Profile Picture
    7 on at
    RE: Sync-NAVApp error The table 'Exchange Contact' cannot be located BC21

    Error:
    Sync-NAVApp :
    Table Exchange Contact :: The table 'Exchange Contact' cannot be located. (6701)
    Table Booking Service :: The table 'Booking Service' cannot be located. (6703)
    Table Booking Mailbox :: The table 'Booking Mailbox' cannot be located. (6704)
    Table Booking Staff :: The table 'Booking Staff' cannot be located. (6705)
    Table Booking Item :: The table 'Booking Item' cannot be located. (6707)

    Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

    It looks like the problem was garbage entries in the Object Metadata Snapshot table.

    Object TypeObject ID Name
    1 6701 Web Part
    1 6703 User Portal User Setup
    1 6704 User Activity Center
    1 6705 Frequent Task
    1 6707 Search Entry

    Once I deleted the entries from the table via SQL, I was able to Sync successfully.

    I would recommend running a force compile on the tables in the old dev environment prior to starting the upgrade.
    This should get the database schema in sync. Note: a synchronize all tables with validation did not clear the bad records.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
Jainam M. Kothari Profile Picture

Jainam M. Kothari 3,481 Super User 2025 Season 2

#2
OussamaSabbouh Profile Picture

OussamaSabbouh 3,277

#3
YUN ZHU Profile Picture

YUN ZHU 1,685 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=bandia+namco++soft+toy" - Nested quantifier +.