3222897 - Adding new Entity Field results in error "ORA-00972: identifier is too long" - SAP SuccessFactors Agent Lifecycle Management

While adding new Entity Field , we got WARNING: This will generate a Foreign Key 'FK_PRD_APP_BusinessManagementOffice' which exceeds a maximum length of 29.

While running Sync DB, we got an error "ORA-00972: identifier is too long".

The Oracle limit for Foreign Key constraints is 29 characters. The system builds the Foreign Key Constraint name based on the following:

FK_{Environment}_{Abbreviated Entity}

For example, a new Entity Field record is created as follows:

Entity Name = 'Appointment

Field Name = ''BusinessManagementOffice

AddForeignKey = 1

This will cause a SyncDB/Restart of the system process to fail. The below Error will be found in the logs:

Caused by: org.springframework.jdbc.BadSqlGrammarException: ConnectionCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

Disclaimer :  Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

SAP SuccessFactors Sales Performance Management

• Agent Lifecycle Management 

Field Name , Constraint , ORA-00972, Identifier , Entity Fields , KBA , CEC-SAL-PPO , Agent Lifecycle Management , How To