Saturday, 3 May 2014

Dimension Error in upgradation to NAV 2013

I currently try to upgrade a database from NAV 2009 R2 to NAV 2013. Now I'm on step 2. While upgrading I get the Error as below:

"Dimension Value ID must have a value in Dimension Set Entry: Dimension Set ID=0, Dimension Code=PROJECT. It cannot be zero or empty."

Global dimensions are stored in 2 places - the transaction record and the appropriate dimension table. Sometimes through incorrect updates, these can get out of sync, which will then cause NAV 2013 upgrade errors.

Look for and fix any out of sync entries.

The issue is persist because there are some posted transactions with a dimension value that does not exist in dimension value table.

You need to find those values and create these dimension value in respective dimension.

In my case:

the reason for the error is data mismatch in analysis view entry and Document Dimension table.

E.g: Dimension Value = 'A0027' in Dimension Value Table and Dimension 4 Value Code = 'A0027  '(space in value) in Analysis View Entry.


No comments:

Post a Comment