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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Sync-NAVApp : The foll...
Small and medium business | Business Central, N...
Suggested Answer

Sync-NAVApp : The following SQL error was unexpected: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong

(0) ShareShare
ReportReport
Posted on by YogiPatel1122 50

I am upgrading V14.0 to V16.0 OnPrem with customized CAL.

I am following the link below:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v14-v16

I am stuck on Task 9: Synchronize tenant:

4.Synchronize the tenant with the Business Central Base Application extension.

Version: NA Business Central 16.0 (Platform 16.0.11233.12061 + Application 16.0.12076.0)

Here is the screen shot of the error.

15_2D00_02_2D00_2021-17_2D00_28_2D00_32.jpg

I have the same question (0)
  • Suggested answer
    Microsoft Dynamics 365 Business Central Profile Picture
    Microsoft Dynamics ... on at
    RE: Sync-NAVApp : The following SQL error was unexpected: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong

    Hi ,

    this error due to Several tables in the upgraded database was missing indexes for NAV keys that had the MaintainSQLIndex

    property enabled.

    so You could run a SQL ServerProfiler trace while running the Sync-NAVApp cmdlet in order to get a list of missing

    indexes per affected table. You could then disable/reenable MaintainSQLIndex on

    the relevant NAV KEY in order to rebuild the missing index. After all affected tables

    were handled in this way the Sync-NAVApp cmdlet could succeed.

    docs.microsoft.com/.../devenv-maintainsqlindex-property

  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,315 User Group Leader on at
    RE: Sync-NAVApp : The following SQL error was unexpected: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong

    run a SQL ServerProfiler trace

  • YogiPatel1122 Profile Picture
    YogiPatel1122 50 on at
    RE: Sync-NAVApp : The following SQL error was unexpected: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong

    Appreciated your reply.

    Can you please provide more information regarding SQL ServerProfilter Trace?

  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,315 User Group Leader on at
    RE: Sync-NAVApp : The following SQL error was unexpected: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong

    Hello Yogi,

    You may follow the below link: www.olisterr.tech/.../how-sql-profiler-can-save-your-day-by.html

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 3,602

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,738 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans