The Load DWH job fails with error similar to this:
2015/09/28 09:28:45 - ClarityDB - isOracle? - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "[schema]"."DWH_TME_ENTRY"."INCIDENT_NAME" (actual: 173, maximum: 15
Steps to Reproduce:
Expected Results: Load DWH job to succeed.
Actual Results: Load DWH job fails with error message ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_TME_ENTRY (see Description for full error message)
This is due to defect CLRT-78267 Load Datawarehouse job expects Incident Description(DWH_TME_ENTRY.INCIDENT_NAME) to be 150 characters instead of 3000 as in IMM_INCIDENTS.DESCRIPTION and fails with ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind when value is exceed
This issue is resolved in Clarity 14.3+
1. Open the PPM view DWH_TIMEENTRY_V in query analyzer tool.
2. Search for the text : INCIDENT.DESCRIPTION. Only one occurrence appears.
Replace INCIDENT.DESCRIPTION with INCIDENT.SUBJECT
3. Save and recompile the view.
4. Run the full Load DWH job