When Status Report has a name > 240 chars long, Full Load DWH job fails

Products

• Clarity PPM SaaS

Issue/Introduction

When a Status Report has a name > 240 chars long, it causes the Full Data Warehouse Load job to fail with:

User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_STATUS_REPORT
    at Processor.processRow(Unknown Source)
    at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1019)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    at java.base/java.lang.Thread.run(Thread.java:829)
    
The error is:
ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INV_STATUS_REPORT. value too long for type character varying(240)

Steps to Reproduce: 

1. In MUX go to Status Reports for a project.
2. Create a new status report with a name > 240 chars long
  e.g. 'Test Status Report - xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
3. Run Full DWH Load job  

Expected Results: 
DWH Load job completes without error.

Actual Results:
DWH Load Job fails with the above error

Workaround: 
Reduce the length of the Name of the Status Report so it contains 240 chars or less and re-run the DWH Load job

Environment

Release: 16.1.1 - Postgres DB only.

Resolution

DE69768 - Addressed in the upcoming 16.1.3 Clarity release.