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)