Clarity PPM: Load Data Warehouse Job Fails with ORA-12899 error

Document ID : KB000121541
Last Modified Date : 26/11/2018
Show Technical Document Details
Issue:

The incremental Load DWH job has been failing with error:

NJS-0401: Execution of job failed.

Example in bg-dwh logs:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_INV_IDEA). SQLERRM : ORA-12899: value too large for column "SC51935PDWH"."DWH_INV_IDEA"."ABCD" (actual: 195, maximum: 60) 
ORA-06512: at line 31

 

 

Cause:

This is due to an attribute that has exceeded the maximum number of allowed characters.

Take the following example. An idea attribute called "Comment" is created with 90 characters maximum allowed.

If 165 characters was allowed, the job would fail.
 

Resolution:
Recreate the attribute with max size = 2000 
In the database, it should show the attribute of data type: varchar2 (4000 byte) 
which should allow at least 2000 characters.