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...
Answers
Dud you check object names in you old database and new fob you are trying to import?
Object names should be unique.
Reports transformation to RDLC
List -1h , Complex List -3h, Document -4h (dev hours)
navisionupgrade.com
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.
Yes i checked i had used a different version.
Thank You
Ya i had used a worldwide version instead of a localised version and hence i faced this issue.
Thank you