Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

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

Posted on by Microsoft Employee

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...

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: NAVISION 2016 UPGRADE ISSUE*****URGENT***

    Generally it looks like you already have this tenant in the database. I support solution, offered by Binesh.

  • Binesh Profile Picture
    Binesh 7,885 on at
    RE: NAVISION 2016 UPGRADE ISSUE*****URGENT***

    Hello,

    Sync - NAVTenant with Force parameter.; but first keep safely backup of your database.

    still if you have error, then you have to delete manually objects from sql server, Like:

    USE [YourDB]

    GO

    DROP TABLE [dbo].[YourCompany$EFT Permission]

    DROP TABLE [dbo].[YourCompany$EFT Setup]

    DROP TABLE [dbo].[YourCompany$EFT Store]

    DROP TABLE [dbo].[YourCompany$EFT Terminal]

    DROP TABLE [dbo].[YourCompany$EFT Tender Type]

    GO

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAVISION 2016 UPGRADE ISSUE*****URGENT***

    Hi Binesh,

    Thank you for your response. :)

    I did follow saurav-nav.blogspot.in/.../microsoft-dynamics-nav-2016-data.html and did my upgrade. That is when in the Sync Nav tenant i found the error that i have mentioned above and am not sure how to progress further. Please help!

    Regards,

    Krithika.N

  • Binesh Profile Picture
    Binesh 7,885 on at

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans