Updating Object attribute result in error ODF-0231

Products

• Clarity PPM SaaS

Issue/Introduction

We are updating status reports attributes and are receiving the ODF-0231 error. Essentially, this is happening on all of the attributes which use the lookup called ‘Project Rating’.

Example from PROD: Admin > Object > Status Report > Attributes > Internal Overall Score: attempting to update as per below, resulting in error

ERROR: ODF-0231: Serious error on inserting or updating object attribute, contact system administrator 

Environment

Release : 16.1.2

Component: Clarity MUX Custom Objects and Custom Investments

Cause

In the app-ca.log we see below error

ERROR 2023-07-25 13:00:42,334 [http-nio-8080-exec-6154] niku.xql2 (******odf.updateObjectDefinitionAttribute) Database Error thrown com.niku.union.persistence.PersistenceException: SQL error code: 0 Error message: ERROR: duplicate key value violates unique constraint "cmn_lookups_u1" Detail: Key (lookup_type, lookup_code)

While troubleshooting, it was identified that two of the lookup values have been deactivated, and are no longer in use, resulting in the error.

Resolution

1. Remove all of the Display Option mappings for each attribute and save
2. Reedit the attribute and set the API Attribute ID and new mappings

Additional Information

Other related Knowledge Articles

• ODF-0231 Creating Attribute (log: column xxxxx already exists)