AnsweredAssumed Answered

DWH Load Job is Failing - DWH_CMN_PRD_VAR_TRN - Errors detected!

Question asked by Kumu002 on Apr 1, 2016
Latest reply on Apr 4, 2016 by Kumu002

Hello All,

 

I have situation where have just imported data warehouse schema and trying to run 1st run of load data warehouse job which is failing with below error log. Have no clue why its failing. Load access right job works fine.

Let me know if any ideas to troubleshoot this. Thanks.

 

INFO 2016-04-01 12:10:12,973 [Thread-261] dwh.event dwh_etl_master - Start of job execution

INFO 2016-04-01 12:10:16,592 [dwh_jb_pre_execution UUID: 9e88fb28-c6cb-498d-b300-4a494d6b9dc8] dwh.event audit table name - & DWH_CFG_AUDIT

INFO 2016-04-01 12:10:16,592 [dwh_jb_pre_execution UUID: 9e88fb28-c6cb-498d-b300-4a494d6b9dc8] dwh.event audit table name - & DWH_CFG_AUDIT

INFO 2016-04-01 12:10:16,592 [dwh_jb_pre_execution UUID: 9e88fb28-c6cb-498d-b300-4a494d6b9dc8] dwh.event audit table name - & DWH_CFG_AUDIT

INFO 2016-04-01 12:10:16,593 [dwh_jb_pre_execution UUID: 9e88fb28-c6cb-498d-b300-4a494d6b9dc8] dwh.event audit table name - & DWH_CFG_AUDIT

INFO 2016-04-01 12:10:16,593 [dwh_jb_pre_execution UUID: 9e88fb28-c6cb-498d-b300-4a494d6b9dc8] dwh.event audit table name - & DWH_CFG_AUDIT

 

ERROR 2016-04-01 12:10:16,886 [DWH_CMN_PRD_VAR_TRN - Join Rows (cartesian product)] dwh.event Join Rows (cartesian product) - Unexpected error

ERROR 2016-04-01 12:10:16,900 [DWH_CMN_PRD_VAR_TRN - Join Rows (cartesian product)] dwh.event Join Rows (cartesian product) - org.pentaho.di.core.exception.KettleException:

Error creating temporary file(s) :

No such file or directory

at org.pentaho.di.trans.steps.joinrows.JoinRows.initialize(JoinRows.java:137)

at org.pentaho.di.trans.steps.joinrows.JoinRows.processRow(JoinRows.java:276)

at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.io.IOException: No such file or directory

at java.io.UnixFileSystem.createFileExclusively(Native Method)

at java.io.File.createNewFile(File.java:1006)

at java.io.File.createTempFile(File.java:1989)

at org.pentaho.di.trans.steps.joinrows.JoinRows.initialize(JoinRows.java:120)

Outcomes