Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K 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
- 280 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 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.7K 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
Options
Getting error when Upgrading from Nav 2009 to 2013R2
Kyhnel
Member Posts: 5
Hi
i'm upgrading a customer from 5.0 to 2013 R2 and on the step from 2009 to 2013R2 (7.1) where Nav generate a SQL procedure and execute i get this error in some of the companies:
"A call to System.Data.SqlClient.SqlCommand.ExecuteNonQuery failed with this message: Column name 'DimVal1' does not exist in the target table or view."
i know that it must be data related but not sure what the problem is.
have any one else run into this issue?
i'm upgrading a customer from 5.0 to 2013 R2 and on the step from 2009 to 2013R2 (7.1) where Nav generate a SQL procedure and execute i get this error in some of the companies:
"A call to System.Data.SqlClient.SqlCommand.ExecuteNonQuery failed with this message: Column name 'DimVal1' does not exist in the target table or view."
i know that it must be data related but not sure what the problem is.
have any one else run into this issue?
0
Comments
In previous versions, people were sloppy with changing dimensions, and these have to be fixed in an upgrade.
Write a routine to see if both the global dimensions in the tables match the respective dimension tables and fix all in consistencies.
If you use the debugger, you can see which NAV statement is calling SQL when it happens.
http://mibuso.com/blogs/davidmachanick/