Code type fields report errors on Nav 4.0 SP2

mihai.valcea
Member Posts: 95
Hi,
I converted the database from Navision 3.6 to Navision 4.0 SP2 opening the 3.6 databse with 4.0 client.
Even the convertion procedure succeded some entry table cannot open. The error reported is related to code type fields and is saying that the code fields contain a value that cannot be user with MBS ....
The two databases have same collation type and the database tests and object compilation are ok.
Have someone encountered this type of error ?
Thanks.
I converted the database from Navision 3.6 to Navision 4.0 SP2 opening the 3.6 databse with 4.0 client.
Even the convertion procedure succeded some entry table cannot open. The error reported is related to code type fields and is saying that the code fields contain a value that cannot be user with MBS ....
The two databases have same collation type and the database tests and object compilation are ok.
Have someone encountered this type of error ?
Thanks.
0
Comments
-
If you are on SQL then it is possible that someone has entered lowecase data directly into a field that Navision is expecting to be a code (UPPERCASE).
If this is the case you will need to correct the data via SQL.This isn't a signature, I type this at the bottom of every message0 -
Thanks, i'lll correct them.0
-
Hi mihai ,please let us know whether it has been corrected or not0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions