I have a new client preparing to move from the native DB to SQL. We discovered this morning overflow errors when trying to restore the backup into SQL on some Sales Invoice Header records for Name and Address.
Upon checking, I discovered that the actual length of the data in the field was 31 characters despite the field length being defined as 30. Was/is there some interesting feature in the native DB that would allow this? Anyone else run into this and/or is there any way to test for this condition easily?
Thanks,
0
Answers
Are you doing the restore on a freshly created SQL database?
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
The strange part was the the actual data in the recor creating the overflow error was 31 characters in length in the native DB, despite the field length being 30. I would have thought that that was not possible even if the client had originally imported data into the Sales Invoice Header from another application [we were not the VAR who did the original conversion to Nav]
I think this explains how your problem occured - from the application developers guide
so the addresses would occupy 32 bytes
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html