Load Data Warehouse DWH Job Fails on Custom Object Instances

Products

• Clarity PPM SaaS

Issue/Introduction

BG DWH log shows:

User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_ODF_XX_TEST_SYSTEM    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)

ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_INV_INVESTMENT. value too long for type character varying(xx)

 

 

 

 

 

Environment

Release : 16.1.0

Resolution

In one reported case, the URL character limit was exceeded from what was set as the Maximum size:

To resolve,
1. Check Exclude from DWH all attributes that are of type URL
2. Run the full load.
3. Check Include in the DWH all atttributes that are of type URL.
4. Run the full Load.