Cannot create an attribute with a specific attribute code in Studio

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

In Studio - Object - Attributes you navigated away whilst updating or deleting an attribute

Now when trying to create an attribute with the same code, you get an error message:

 

ERROR 2024-05-29 08:38:38,712 [http-nio-8080-exec-2442] niku.xql2 (clarity:admin:6504738__92DADAEB-6BB5-4093-A6D5-1226BC5DE353:odf.addObjectDefinitionAttributeAndExit) (10117c23-c673-44a8-ac0f-66e89a36f320) Database Error thrown com.niku.union.persistence.PersistenceException: SQL error code: 0
Error message: ERROR: column "test_admin" of relation "odf_ca_project" already exists
Executed: alter table odf_ca_project add test_admin  character varying(100) null 

Resolution

Use another attribute code to create a new attribute

Note:

• Broadcom Support does not recommend navigating away from any action in Studio such as create/update/delete attribute in Studio - Object - Attributes
• Please leave any sessions, even if long running, complete before continuing to avoid issues