Custom Attribute Creation in Investment Object Fails

Products

• Clarity PPM On Premise

Issue/Introduction

We are encountering an error while creating a custom Attribute "abcd" in Investment Object. Message: Please see the log for more details.

APP Logs:

ERROR ... ..niku.xql2 (clarity:......:odf.addObjectDefinitionAttribute)... Database Error thrown 
com.niku.union.persistence.PersistenceException: 
SQL error code: 4021
Error message: ORA-04021: timeout occurred while waiting to lock object ODF_CA_INV

...alter table odf_ca_inv add abcd  number null ....Caused by: Error: 4021, Position : 0, Sql = alter table odf_ca_inv add abcd number null, OriginalSql = alter table odf_ca_inv add abcd number null, Error Msg = ORA-04021: timeout occurred while waiting to lock object.ODF_CA_INV

ERROR 2024-08-05 21:24:42,079 [https-jsse-nio2-9051-exec-1927] xql2.xbl (clarity:.....:odf.addObjectDefinitionAttribute) (...) Error inserting/updating attribute abcd object inv message is System error. Contact system administrator.

Environment

Clarity 16.2

Resolution

As per the logs, there is no application-level lock on the object. The Oracle error "ORA-04021" indicates the database object being locked. Working with the DBA to look at possible stuck or blocking sessions, possibly looking at dba_ddl_locks

References:

Understanding Why ORA-04021 TIMEOUT OCCURRED WHILE WAITING TO LOCK OBJECT Happens

ORA-04021: timeout occurred while waiting to lock object