Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 317 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problem converting NL SQL DB 3.70 to 4.0 SP1
rvveldhuyzen
Member Posts: 2
I have a problem with a technical conversion of a Dutch SQL DB from 3.70 to 4.0SP1.
When I open the database it asks if I want to convert it. When I confirm that it starts converting. After a while a get an SQL statement error:
207,"42S22",[Microsoft][ODBC SQL Sever Driver][SQL Server]Invalid column name 'Type'.
16945,"42000",[Microsoft][ODBC SQL Sever Driver][SQL Server]The cursor was not declared.
SQL:
Select O."id" FROM "Object" AS O WHERE O."Type"=? ORDER BY O."ID"
When I look in the Object table I see that the fields have Dutch fieldnames. I tried to translate the fieldnames from an English db. Afterthat I get the error from Navision that field 'Type' does not exist in the table Object. :-k
When I restore the backup in a new 4.0 SP1 DB I have no problem. But the database is huge and I think it will take several days to restore it. So thats my very last option. :roll:
I have taken a look in the fin.stx files and compared the 3.70 and 4.0SP1 version. I noticed that the ''//DB Object Table" part differs. In 3.70 there are Dutch names and in the 4.0SP1 there are only English names for the fields. I think this is the problem. Another problem is I am not allowed to change the stx file. ](*,)
I am all out of options. Is there somebody out here that knows how I can solve this?
When I open the database it asks if I want to convert it. When I confirm that it starts converting. After a while a get an SQL statement error:
207,"42S22",[Microsoft][ODBC SQL Sever Driver][SQL Server]Invalid column name 'Type'.
16945,"42000",[Microsoft][ODBC SQL Sever Driver][SQL Server]The cursor was not declared.
SQL:
Select O."id" FROM "Object" AS O WHERE O."Type"=? ORDER BY O."ID"
When I look in the Object table I see that the fields have Dutch fieldnames. I tried to translate the fieldnames from an English db. Afterthat I get the error from Navision that field 'Type' does not exist in the table Object. :-k
When I restore the backup in a new 4.0 SP1 DB I have no problem. But the database is huge and I think it will take several days to restore it. So thats my very last option. :roll:
I have taken a look in the fin.stx files and compared the 3.70 and 4.0SP1 version. I noticed that the ''//DB Object Table" part differs. In 3.70 there are Dutch names and in the 4.0SP1 there are only English names for the fields. I think this is the problem. Another problem is I am not allowed to change the stx file. ](*,)
I am all out of options. Is there somebody out here that knows how I can solve this?
0
Comments
(you can try to create new database in SP1 and compare the data from this database with data from your old database).
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
We've got an database created with german STX.
Than we've got the same error you descriped as we want to convert with an english STX.
With the german STX it works without errors.
If you have an dutch database you have to take the dutch STX.
This work's only with 4.00 without SP1.
You must first convert to 4.00 then convert to 4.00 SP1.