NAVISION 2016 UPGRADE ISSUE*****URGENT****

Krithika_92

Hi All,

I am doing an Upgrade in NAVISION from NAV 2013 R2 to NAV 2016. After importing all the customized objects and the upgrade toolkit objects in my NAV 2016 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...

swpolo

Hi Krithika_92,
Dud you check object names in you old database and new fob you are trying to import?
Object names should be unique.

Wisa123

Had this happen before once.

1.) Upgraded to new Version
2.) Noticed i had Objects from an old Add-On we dont have in our license anymore
3.) These weren't deletable from DEV-Environment
4.) Deleted these objects from SQL Side (yes i know that's rude, dont judge me)

After those 4 steps this problem occured.
The Table was deleted, however the TableData Object still remained.

5.) Deleted the TableData Objects for those Add-On Tables
6.) Success

This is a BAD solution, but the only one that worked for me, i don't encourage you to do this.
And as always when upgrading, make lots and lots of backups before you do anything and after every step.

swpolo

Hi Krithika_92,
Dud you check object names in you old database and new fob you are trying to import?
Object names should be unique.

Wisa123

Had this happen before once.

1.) Upgraded to new Version
2.) Noticed i had Objects from an old Add-On we dont have in our license anymore
3.) These weren't deletable from DEV-Environment
4.) Deleted these objects from SQL Side (yes i know that's rude, dont judge me)

After those 4 steps this problem occured.
The Table was deleted, however the TableData Object still remained.

5.) Deleted the TableData Objects for those Add-On Tables
6.) Success

This is a BAD solution, but the only one that worked for me, i don't encourage you to do this.
And as always when upgrading, make lots and lots of backups before you do anything and after every step.

Krithika_92

Hi,

Yes i checked i had used a different version.

Thank You

Krithika_92

Hi Wisa123,

Ya i had used a worldwide version instead of a localised version and hence i faced this issue.

Thank you