NAV 2017 upgrade error while Sync tenant

Business Central/NAV Technical Forum
1

Hi All,

I am doing an Upgrade in NAVISION from NAV 2013 R2 to NAV 2017. After importing all the customized objects and the upgrade toolkit objects in my NAV 2017 database, and when i run the Sync - NAVTenant i am facing the below mentioned error

The following SQL error was unexpected:
There is already an object named ‘CompanyName$UPG Posting Exch_ Column Def’ in the database.

I am unable to proceed further and i don’t know how to solve this issue…Please kindly render your timely help.

Very Eagerly awaiting a solution…

2

Hi,

Please check this link:- community.dynamics.com/…/200724

3

Hi naveengour

Firstly, you’re running Sync-NAVTenant to synchronize 2017 database right? If you are getting error in powershell on executing this command then dont’ go through powershell instead run your NAV 2017 Development environment as administrator and go to tools → Sync. Schema for all tables → Force

I guess this should work for you.

4

Hi,

I need to run the schema by with Validation.

I tried from powerhsell as weel as from NAV dev environment but both time same result.