Load DWH Job fails on "DWH_TME_ENTRY"."INCIDENT_NAME"

book

Article ID: 32175

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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:

  1. Connect to Clarity UI, with configured Incidents and Investments
  2. Go to any incident linked to an investment
  3. Modify the description to be more than 150, but less than 3000 characters as per imm_incidents table limits
  4. Save
  5. Now enter time for this incident on a timesheet, save and submit it.
  6. Ensure IMM_INCIDENTS.LAST_UPDATED_DATE and PRTIMEENTRY.PRMODTIME for it is earlier than this date
    SELECT DISTINCT DWH_DIM_START_DATE FROM DWH_CFG_SETTINGS
  7. This is required because the update happens for all data prior to the Dimension start date.
  8. Run Load DWH job.

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)

Cause

This is due to defect CLRT-78267 Load Dataware house 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 exceeded

Environment

Release: 14.2
Component: Data Warehouse (DWH)

Resolution

This issue is resolved in Clarity 14.3+

Workaround:

  1. Open the PPM view DWH_TIMEENTRY_V in the 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

 

Additional Information

See also: Load DWH job frequently reported issues