AnsweredAssumed Answered

Error during Load Data Warehouse: Errors during execution of table DWH_FIN_TRANSACTION

Question asked by GeorgSchmid2014 on Jul 10, 2015
Latest reply on May 9, 2017 by Nika_Hadzhikidi

Dear all,

 

The full load of our "Load Data Warehouse" job is not running through.

 

From the bg-dwh.job I can see that the table DWH_FIN_TRANSACTION seems to be the problem:

2015/07/10 12:16:02 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error

2015/07/10 12:16:02 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_FIN_TRANSACTION

2015/07/10 12:16:02 - User Defined Java Class.0 - at Processor.processRow(Processor.java:64)

2015/07/10 12:16:02 - User Defined Java Class.0 - at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)

2015/07/10 12:16:02 - User Defined Java Class.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)

2015/07/10 12:16:02 - User Defined Java Class.0 - at java.lang.Thread.run(Thread.java:745)

2015/07/10 12:16:02 - dwh_etl_interface_dim - dwh_etl_interface_dim

2015/07/10 12:16:02 - dwh_etl_interface_dim - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!

2015/07/10 12:16:02 - dwh_etl_interface_dim - dwh_etl_interface_dim

 

Unfortunatly,no specific information is given on which data set could have caused this issue.


In consequence, the table DWH_FIN_TRANSACTION is empty.


Has anyone an idea where to look for the root cause?

Outcomes