Error with Custom Investment in New UX

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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.

Cause

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.

Environment

Clarity PPM 15.x

Resolution

In Oracle 12.2.0.1.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