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 220.127.116.11.0 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