2016/01/12 16:26:57 - Write to log 2.0 - ------------> Linenr 1------------------------------
2016/01/12 16:26:57 - Write to log 2.0 - Running Post Execution for 'DWH_LKP_USER_VALUE1':
2016/01/12 16:26:57 - Write to log 2.0 - update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date(<DWH_LOAD_END_DATE>, 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_LKP_USER_VALUE1';
2016/01/12 16:26:57 - Write to log 2.0 -
2016/01/12 16:26:57 - Write to log 2.0 - DWH_LOAD_END_DATE = 2016/01/12 16:26:57
2016/01/12 16:26:57 - Write to log 2.0 -
2016/01/12 16:26:57 - Write to log 2.0 - ====================
2016/01/12 16:26:57 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:26:57 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:26:57 - Execute SQL script 2.0 - Finished reading query, closing connection.
2016/01/12 16:26:57 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:26:58 - dwh_tr_post_execution - Loading transformation from XML file [file:///user/tomcat/tc70DT01_A01/clarity/META-INF/datamart/etl_scripts/dwh_cmn_etl_jobs/dwh_tr_post_execution.ktr]
2016/01/12 16:26:58 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2016/01/12 16:27:03 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:03 - Write to log 2.0 -
2016/01/12 16:27:03 - Write to log 2.0 - ------------> Linenr 1------------------------------
2016/01/12 16:27:03 - Write to log 2.0 - Running Post Execution for 'DWH_LKP_USER_VALUE2':
2016/01/12 16:27:03 - Write to log 2.0 - update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date(<DWH_LOAD_END_DATE>, 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_LKP_USER_VALUE2';
2016/01/12 16:27:03 - Write to log 2.0 -
2016/01/12 16:27:03 - Write to log 2.0 - DWH_LOAD_END_DATE = 2016/01/12 16:27:03
2016/01/12 16:27:03 - Write to log 2.0 -
2016/01/12 16:27:03 - Write to log 2.0 - ====================
2016/01/12 16:27:03 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:03 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:03 - Execute SQL script 2.0 - Finished reading query, closing connection.
2016/01/12 16:27:03 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:09 - dwh_tr_post_execution - Loading transformation from XML file [file:///user/tomcat/tc70DT01_A01/clarity/META-INF/datamart/etl_scripts/dwh_cmn_etl_jobs/dwh_tr_post_execution.ktr]
2016/01/12 16:27:09 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2016/01/12 16:27:09 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:09 - Write to log 2.0 -
2016/01/12 16:27:09 - Write to log 2.0 - ------------> Linenr 1------------------------------
2016/01/12 16:27:09 - Write to log 2.0 - Running Post Execution for 'DWH_LKP_VENDOR_STATUS':
2016/01/12 16:27:09 - Write to log 2.0 - update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date(<DWH_LOAD_END_DATE>, 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_LKP_VENDOR_STATUS';
2016/01/12 16:27:09 - Write to log 2.0 -
2016/01/12 16:27:09 - Write to log 2.0 - DWH_LOAD_END_DATE = 2016/01/12 16:27:09
2016/01/12 16:27:09 - Write to log 2.0 -
2016/01/12 16:27:09 - Write to log 2.0 - ====================
2016/01/12 16:27:09 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:09 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:09 - Execute SQL script 2.0 - Finished reading query, closing connection.
2016/01/12 16:27:09 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:15 - dwh_tr_post_execution - Loading transformation from XML file [file:///user/tomcat/tc70DT01_A01/clarity/META-INF/datamart/etl_scripts/dwh_cmn_etl_jobs/dwh_tr_post_execution.ktr]
2016/01/12 16:27:15 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2016/01/12 16:27:15 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:15 - Write to log 2.0 -
2016/01/12 16:27:15 - Write to log 2.0 - ------------> Linenr 1------------------------------
2016/01/12 16:27:15 - Write to log 2.0 - Running Post Execution for 'DWH_LKP_WBS_TYPE':
2016/01/12 16:27:15 - Write to log 2.0 - update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date(<DWH_LOAD_END_DATE>, 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_LKP_WBS_TYPE';
2016/01/12 16:27:15 - Write to log 2.0 -
2016/01/12 16:27:15 - Write to log 2.0 - DWH_LOAD_END_DATE = 2016/01/12 16:27:15
2016/01/12 16:27:15 - Write to log 2.0 -
2016/01/12 16:27:15 - Write to log 2.0 - ====================
2016/01/12 16:27:15 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:15 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:15 - Execute SQL script 2.0 - Finished reading query, closing connection.
2016/01/12 16:27:15 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:21 - dwh_tr_post_execution - Loading transformation from XML file [file:///user/tomcat/tc70DT01_A01/clarity/META-INF/datamart/etl_scripts/dwh_cmn_etl_jobs/dwh_tr_post_execution.ktr]
2016/01/12 16:27:21 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2016/01/12 16:27:21 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:21 - Write to log 2.0 -
2016/01/12 16:27:21 - Write to log 2.0 - ------------> Linenr 1------------------------------
2016/01/12 16:27:21 - Write to log 2.0 - Running Post Execution for 'DWH_LKP_WORK_STATUS':
2016/01/12 16:27:21 - Write to log 2.0 - update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date(<DWH_LOAD_END_DATE>, 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_LKP_WORK_STATUS';
2016/01/12 16:27:21 - Write to log 2.0 -
2016/01/12 16:27:21 - Write to log 2.0 - DWH_LOAD_END_DATE = 2016/01/12 16:27:21
2016/01/12 16:27:21 - Write to log 2.0 -
2016/01/12 16:27:21 - Write to log 2.0 - ====================
2016/01/12 16:27:21 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:21 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2016/01/12 16:27:21 - Execute SQL script 2.0 - Finished reading query, closing connection.
2016/01/12 16:27:21 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
null
ERROR 2016-01-12 16:28:15,046 [Dispatch pool-5-thread-6 : bg@appduv001c.machine.test.group (tenant=clarity)] niku.njs
java.lang.Exception: ETL Job Failed. Please see log bg-dwh.log for details.
at com.ca.clarity.etl.kettle.AbstractKettleJob.runETLJob(AbstractKettleJob.java:188)
at com.ca.clarity.etl.kettle.AbstractKettleJob.executeETLJob(AbstractKettleJob.java:67)
at com.ca.clarity.etl.kettle.DataWareHouseKettleJob.executeETLJob(DataWareHouseKettleJob.java:61)
at com.ca.clarity.njs.listeners.ETLJobListener.scheduledEventFired(ETLJobListener.java:31)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
ERROR 2016-01-12 16:28:15,046 [Dispatch pool-5-thread-6 : bg@appduv001c.machine.test.group (tenant=clarity)] niku.njs Error executing job: 5171055
java.lang.Exception: ETL Job Failed. Please see log bg-dwh.log for details.
at com.ca.clarity.etl.kettle.AbstractKettleJob.runETLJob(AbstractKettleJob.java:188)
at com.ca.clarity.etl.kettle.AbstractKettleJob.executeETLJob(AbstractKettleJob.java:67)
at com.ca.clarity.etl.kettle.DataWareHouseKettleJob.executeETLJob(DataWareHouseKettleJob.java:61)
at com.ca.clarity.njs.listeners.ETLJobListener.scheduledEventFired(ETLJobListener.java:31)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)