Notifications
Announcements
No record found.
*This post is locked for comments
Hello,
It has no data, that's why you got error, or it may be other issue also.
post some more details, in which trigger you get.
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.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
