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)
Release : 16.1.0
In one reported case, the URL character limit was exceeded from what was set as the Maximum size:
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.