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 / Microsoft Dynamics NAV (Archived) / NAVISION 2016 UPGRADE ...
Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Binesh Profile Picture
    Binesh 7,885 on at
    RE: NAVISION 2016 UPGRADE ISSUE*****URGENT***

    Hello krithika.N,

    Follow these links...

    Microsoft Dynamics NAV 2016 - Data Migration.

    Refer Here For How To Run Sync-Tenant.

    Upgrading to Microsoft Dynamics NAV 2016

    Upgrading the Data

  • Community Member Profile Picture
    Community Member 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
    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

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 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.

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 > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans