I'm try to restore a 4.00 database backup in a new NAV 2009 SP1 SQL database. During the restore I'm receiving the following message:
'Item unit of Measure table contains a value in a code field that cannot be used with Micorosoft Dynamics NAV Classic. Field: Item No., Value: WP BIJOUX MP HEADERS
(The Item no. value seems to be a valid value. It doesn't exceed the 20 characters)
Any ideas?
0
Comments
Try going to the collation settings (File->Database->Alter -> Collation tab) and untick "Validate Code Page".
if that works you need to find out which character in "WP BIJOUX MP HEADERS" is not acceptable. My guess would be that one of the <spaces> is not really a space. Or it could be you imported this item via SQL or ODBC and one of the characters is not as it seems. To test this, copy paste it into the Description field, and see if the Search description is identical.
You can write some simple code to locate the errors and fix them. Just crate a reprot that scans the table and add a line like:
Beware though that this is not a good way to fix them, since they will no longer link to the Item table correctly.
Yes, I double checked for more item nos. It looked like there was only one. So, I think I'm fine. But thanks for the note.