Thursday, August 8, 2019

Cannot import the data because the table with the ID ….

Few weeks ago, I was trying to import a company from a Test database to Development database. I have exported the data from the test database using the Export to Data File option which creates a .navdata file and if the both databases have the same schema you can import that file into another database.

You can read more about How to Export/Import Data from the below link
https://docs.microsoft.com/en-us/dynamics-nav/exporting-and-importing-companies-and-other-data

In my case, both databases have the same schema, but when I try to use the Import Data, I got the below error
Cannot import the data because the table with the ID 27 in the specified file has different fields or key definitions than the application database. Make sure that you are importing data into the same application as it was exported from

I have check the Table 27 in both databases and they have the same schema, but I still get the same error. I have compiled the objects, and restarted the NAV Service just to confirm the schema is in sync but that did not resolve the issue.



The issue was I have a extension (“Sales and Inventory Forecast”) installed in Test Database but not in the other database, so I have uninstalled the extension from the Test database and re-exported the data. This time the import ran without any error.

So, when you use Export/Import Data option, make sure you check the same extensions are installed in both the databases.
Share:

8 comments:

ivomol said...

If extension is uninstalled before export: are data from this extension exported from source database to navdata file?
If yes: are extension data imported to target database although extension is there not installed?

Suresh Kulla said...

When an extension is uninstalled the data is not exported to the navdata file.

Raymond said...

"The issue was I have a extension (“Sales and Inventory Forecast”) installed in Test Database but not in the other database, so I have uninstalled the extension from the Test database and re-exported the data. This time the import ran without any error." - is the issue caused by this particular extension?

yasiralinasir said...

I never comment on blogs but your article is so best that I never stop myself to say something about it. You’re amazing Man, I like it Database Errors... Keep it up

smartdeveloper said...

Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article.
Thanks for sharing such a nice info.I hope you will share more information like this. please keep on sharing!

internship in chennai
internship in chennai for cse
internship for mba in chennai
internship in chennai for hr
internship in chennai for mba
companies for internship in chennai
internship in chennai for ece
paid internship in chennai
internship in chennai for biotechnology
internship in chennai for b.com students

ROCKY said...

importer database Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me.

tradeimexinfo said...

I read your post and this blog is very good. You have provided good knowledge in this blog. This blog really impressed me. Thank you for sharing your knowledge with all of us. Indonesia Export Data

Grace Mia said...

Thanks for Sharing..Keep Update…

Web Hosting is the process of buying space for a website on the World Wide Web.

What is Web Hosting
Web Hosting