Getting error when Upgrading from Nav 2009 to 2013R2

Kyhnel

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?

davmac1

Hi,
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.