search cancel

Error with Custom Investment in New UX


Article ID: 141560


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


We recently created a custom investment in one of our development environments. 

Everything was working fine and all of a sudden, any change we try to do to an instance of this custom investment generates an error and the changes are not saved.


Issue is being caused when a pick list is created. Below is the error observed in the logs:

SQL error code: 972

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00972: identifier is too long

When attempting to execute the query in SQL Developer, below is the error:

ORA-00972: identifier is too long

00972. 00000 -  "identifier is too long"

*Cause:    An identifier with more than 30 characters was specified.

*Action:   Specify at most 30 characters.


Clarity PPM 15.x


In Oracle TABLE_NAME column in the USER_TABLE is VARCHAR2(128) where in 12.1 it is VARCHAR2(30).

In Oracle 12.2 and above the maximum object name length is 128 bytes.

In Oracle 12.1 and below the maximum object name length is 30 bytes.

Upgrade to Oracle 12.2