Default Dimensions error

beetlestone

Hi everyone.
I have a customer who is using NAV2013 R2 GB 7.10.38053.
One user at this customer is unable to add one specific Dimension value to any record - Default Dimensions, Document Dimensions etc. The error message is

"The field Dimension Value Code of table default Dimension contains a value (AGG001) that cannot be found in the related table (Dimension Value)"

The data they are trying to add is for a PRACTICE dimension and the value is CL.
The content of the error message (AGG001) is wrong, in that the user is not trying to use this value, nor change from this value. The AGG001 value actually relates to a CUSTOMER dimension.

This user can add any other Dimension Value to any record, other than PRACTICE : CL.
Every other user can add PRACTICE : CL to any record.

We have tried to delete the PersonalizationStore.xml, we cannot delete the Dim Value through the GUI because it has already been used in posted docs, tried different hardware for the user.

What does make a difference is if we change the TableRelation property of the Dimension Value Code field on Default Dimension. If the property value is deleted, then the user could manually enter the value without validation. Put the property value back and the error returns.

We have re-compiled objects, logged out in, but now need to have some other suggestions.

Anyone able to help?

cheers,
Darren

Rob_Hansen

I can't think of a scenario where this would ever be done, but you haven't applied a Security Filter to the Dimension Value table under this user, have you?

beetlestone

Hi Rob,
no security filters have been set. We have run the Permission table and all appears to be in order.

It should be noted that the database does have a CRONUS company, and when creating the DIMENSION and Value in CRONUS, the user is able to assign the value to records as required.
All of the other companies are copies of the LIVE company, taken at different times over the last few months. The problem exists in all of the user companies.

Darren

Rob_Hansen

I assume you've already tried debugging on the user's session to see where the code is erroring out to look at record/variable values, etc.? There's something wonky going on if the error message is referencing another dimension/value.

beetlestone

Tried debugging, but it errors out before reaching any code, that's how I established that the Field TableRelation property affected behaviour in this case.

The quoted Dim value is actually the first one in Dimension Value table, even if it is for a different Dimension Code.

It is just really odd that this affects only one users ability to apply one dimension value to every record. Everyone else, every other dimension value and every other dimension work without a problem.

In a company without transactions, the problem occurs. Deleting the Dim value, and then recreating it does not change the behaviour, either.