Share
Report*This post is locked for comments
You’re offline. This is a read only version of the page.
*This post is locked for comments
Agree with Saurav, usually this issue comes up when some special symbols, e.g. trailing spaces are present in the code numbers. NAV fails to process that and shows that error. In order to resolve it, you need to use SQL tools to rename incorrect values in the database.
Another option is incorrect customization.
Hi,
If i am not wrong this database is upgraded from Pre-2013 Version (2009,5.0,4SP3..).
The Problem is with the data which need to be corrected before the upgrade. The Problem is -
The Primary key of the table has spaces/special characters in the values, which NAV 2013 and Later exe try to trim when it shows you record on the page, but the data at the backend in SQL is with spaces / special characters.
Reason behind Issue -
1. The user was copying data from Excel in old nav version.
2. Data in Navision table via an external application which may have these special characters / spaces in the data.
You can check that data from SQL - when you copy such data from SQL to notepad, it added a line break after the column value.
Resolution -
If you are planning to do an upgrade data migration, make sure you rename all the records in the old version before starting data migration.
If you are already upgraded then I am not sure how you can do it, because if you do it from SQL the related records will be updated as no table relation in SQL.
All responses (
Answers (
28,094
