Load Data Warehouse Job Failure

Document ID : KB000101906
Last Modified Date : 25/06/2018
Show Technical Document Details
Issue:
The full load dwh job is failing. Found the error below in the bg-dwh.log file.

User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_PROJECT at Processor.processRow(Processor.java:64) at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) at java.lang.Thread.run(Thread.java:745) Error 6/15/18 4:50 AM User Defined Java Class - Unexpected error Error 6/15/18 4:50 AM dwh_etl_interface_dim - Errors detected! Job Completed 6/15/18 4:50 AM NJS-0401: Execution of job failed. bg-dwh.log has been attached to the case
Resolution:
Please take the following steps to resolve this job failure and proceed with your validation checks: 

Admin > studio >objects > investments 
exclude all Data Warehouse attributes 

Run the full Load DWH job to see if it completes.