Invalid unitid value xxxxxxx given for attribute yyyyyyy

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When creating am Idea using the Add button, it errors with the following message:
Invalid unitid value 5005002 given for attribute odf_bl_r_n276271046.

The attribute is the ID of the Security OBS associated with the Idea object. There is no OBS Unit with this ID. The error started after the client did a refresh from Prod and the error does not happen in Prod.  

The app-ca.log file states:
rest.validation (clarity:myuser:mysession:PPM_REST_API) ExceptionInfo ::  Could not create resource. Resource name: ideas. Error code: revmgr.invalidObsUnitId Error message: Invalid unitId value 5005002 given for attribute odf_bl_r_n276271046.

Another thing to note is that when the user tries to set a default for the Security OBS attribute, after clicking save, the value selected is cleared out and there is no default set on the Admin side.

Cause

This problem is sometimes caused by an entry stored on the table odf_default_overrides table for that attribute.

Resolution

Please run the following select statement against the DB

• SELECT * from odf_default_overrides where object_code = 'idea' and attribute_code ='odf_bl_r_n276271046'

If you get results, please run the below delete statement:

• delete from odf_default_overrides where object_code = 'idea' and attribute_code ='odf_bl_r_n276271046'

Please note:

• The object_code might vary and in this specific case is Idea, because the affected object is an idea.
• The attribute_code might vary and is specific to the affected OBS attribute id that can be seen on the log file