SQL Migration - invalid value in the code field?

Cindy101
Cindy101 Member Posts: 33
edited 2009-05-27 in NAV/Navision Classic Client
Hello,

I'm trying to restore an upgraded native navision DB (from 3.6 to 5.0 sp1) database to a SQL Server Navision DB and I'm running into the following error message:

"The customer table contains a value in a code field that cannot be used with Microsoft Dynamics NAV"

The field that it is choking on is Search Name and the value it gives is a bunch of symbols and wingding looking things, such as ™.

Has anyone seen this before, know how to fix it?

Thanks!

Answers

  • Cindy101
    Cindy101 Member Posts: 33
    Solved: Turns out they had some customers in a seldom used company whose names did not translate well (Chinese I think) to the native DB, I had to rename these customers.

Categories