web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Copy Company Error &qu...
Microsoft Dynamics NAV (Archived)

Copy Company Error "Invalid Object Name"

(1) ShareShare
ReportReport
Posted on by Community Member

Hi Good Day!

We have a NAV 2013 R2 installed in a Windows Server 2012 with SQL Server 2012.

I'm trying to copy the company and it prompts me the error

"The following SQL error was unexpected. Invalid Object Name 'dbo.[tablename]'".

I checked from the NAV Dev Environment and Database the table exists.

Please help. Thank you for your inputs.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    One more thing the invalid table is a user custom table and doesn't contain any data. Recompiled it already but still the same error.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at

    Hi,

    Check two things -

    1.  From Dev. Enviroment or Role Tailored client check your EXE build.

    2. From SQL Server managment studio check the custom table exist in the database with the same name as appear on error message.

    Let us know your findings.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 9,125 Super User 2026 Season 1 on at

    Hey earldelrosario

    Try this.

    Open SQl Server management studio and then navigate to below path

    Edit -> IntelliSense -> Refresh Local Cache

    Now try and check.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at

    Hie Earldelrosario,

    Try "Synchronize Schema" for all tables - FORCE in development environment.

    I once had same problem and i resolved like this.

    Hope it works for you.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    This has happen to me several time. Most of the time this happens when you rename a table ID. Sometimes Development Env. shows the correct picture to you, but in the SQL side it does not reflect the modification you have done. To solve this what I did was delete the table from Development Env. and then delete it again from the SQL side as well.

    Then sync the table using Dynamics NAV Dev. Environment.

  • Community Member Profile Picture
    Community Member on at

    Hi RackWith NAV,

    Tried this steps and still got the same error.

    Thanks for your suggestion.

    Regards

  • Community Member Profile Picture
    Community Member on at

    Hi Guys,

    Can you be more specific were I can do this steps. Our NAV system is implemented by a different person. He left and taught me how to manage it and do minor customization in RTC. I'm fairly new with NAV and just been learning how to do things in NAV development environment.

    Now my boss wants to use the system for the new company he's building so I was asked to setup a new company in NAV for this purpose.

    Thanks for your understanding.

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at

    Please try this:

    1. Delete the records from the Object Metadata table.

    2. Executed the Build Server Application Objects

    3. Compiled all the objects.

    4. Relogin into NAV 2013 R2.

    5. Try to copy the company.

    Simple way in layman language.

  • Community Member Profile Picture
    Community Member on at

    Hi Ashwini,

    Tried what you said but still got the same error.

    I tried running it in Powershell got a more detailed error message. Here is the screencapNAVCopyError.jpg

    There is no table of such name in the database and in the NAV dev environment.

    Best Regards.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at

    Hi,

    You did not answer my question but i feel that your navision build is less that 36281.

    Before this build there was a problem that you are facing.

    If that hold true please download NAV CU which have build no higher than 36281 or i would suggest to download latest cumulative update and follow steps as discussion below -

    dynamicsuser.net/.../90238

    Let us know how it goes after that. (Please do all on a test database before doing it on production environment)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April 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