015/12/30 12:15:19 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2015/12/30 12:15:19 - Execute SQL script 2.0 - Error while running this step!
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1432)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatements(Database.java:1538)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:225)
2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 2 more
2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.w(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.s(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.execute(Unknown Source)
2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1406)
2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 4 more
2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished reading query, closing connection.
2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
null
ERROR 2015-12-30 12:15:19,523 [dwh_etl_interface_dim - User Defined Java Class] dwh.event User Defined Java Class - Unexpected error
ERROR 2015-12-30 12:15:19,531 [dwh_etl_interface_dim - User Defined Java Class] dwh.event User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_CMN_EXCHANGE_RATE
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 2015-12-30 12:15:19,537 [dwh_etl_interface_dim UUID: 0e3c2501-76e6-456e-92ba-251e12a7ed50] dwh.event dwh_etl_interface_dim - Errors detected!
INFO 2015-12-30 12:15:19,537 [dwh_etl_interface_dim - User Defined Java Class] dwh.event dwh_etl_interface_dim - dwh_etl_interface_dim
INFO 2015-12-30 12:15:19,538 [dwh_etl_interface_dim - User Defined Java Class] dwh.event dwh_etl_interface_dim - dwh_etl_interface_dim
ERROR 2015-12-30 12:15:19,542 [dwh_etl_interface_dim UUID: 0e3c2501-76e6-456e-92ba-251e12a7ed50] dwh.event dwh_etl_interface_dim - Errors detected!
INFO 2015-12-30 12:15:19,552 [Thread-14] dwh.event dwh_etl_master - Job execution finished
ERROR 2015-12-30 12:15:19,761 [Dispatch pool-5-thread-3 : bg@appduv001c.machine.test.group (tenant=clarity)] dwh.event ETL Job Failed. Log details below:
2015/12/30 12:15:11 - User Defined Java Class.0 - *****************************************************************
2015/12/30 12:15:11 - User Defined Java Class.0 -
2015/12/30 12:15:11 - User Defined Java Class.0 - STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_CMN_EXCHANGE_RATE
2015/12/30 12:15:11 - User Defined Java Class.0 -
2015/12/30 12:15:11 - User Defined Java Class.0 - *****************************************************************
2015/12/30 12:15:19 - User Defined Java Class.0 - DWH_CMN_EXCHANGE_RATE - Job Log: 2015/12/30 12:15:19 - dwh_jb_post_execution - Starting entry [ClarityDB - isOracle?]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_jb_post_execution - Starting entry [dwh_tr_post_execution]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ------------> Linenr 1------------------------------
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Running Post Execution for 'DWH_CMN_EXCHANGE_RATE':
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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_CMN_EXCHANGE_RATE';
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - DWH_LOAD_END_DATE = 2015/12/30 12:15:19
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ====================
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Error while running this step!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1432)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatements(Database.java:1538)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:225)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 2 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.w(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.s(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.execute(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1406)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 4 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished reading query, closing connection.
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_jb_post_execution - Finished job entry [dwh_tr_post_execution] (result=[false])
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_jb_post_execution - Finished job entry [ClarityDB - isOracle?] (result=[false])
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ------------> Linenr 1------------------------------
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Running Post Execution for 'DWH_CMN_EXCHANGE_RATE':
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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_CMN_EXCHANGE_RATE';
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - DWH_LOAD_END_DATE = 2015/12/30 12:15:19
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ====================
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Error while running this step!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1432)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatements(Database.java:1538)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:225)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 2 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.w(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.s(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.execute(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1406)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 4 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished reading query, closing connection.
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - null
2015/12/30 12:15:19 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - 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_CMN_EXCHANGE_RATE
2015/12/30 12:15:19 - User Defined Java Class.0 - at Processor.processRow(Processor.java:64)
2015/12/30 12:15:19 - User Defined Java Class.0 - at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)
2015/12/30 12:15:19 - User Defined Java Class.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - User Defined Java Class.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - dwh_etl_interface_dim - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - dwh_etl_interface_dim - dwh_etl_interface_dim
2015/12/30 12:15:19 - dwh_etl_interface_dim - dwh_etl_interface_dim
2015/12/30 12:15:19 - dwh_etl_interface_dim - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:11 - User Defined Java Class.0 - *****************************************************************
2015/12/30 12:15:11 - User Defined Java Class.0 -
2015/12/30 12:15:11 - User Defined Java Class.0 - STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_CMN_EXCHANGE_RATE
2015/12/30 12:15:11 - User Defined Java Class.0 -
2015/12/30 12:15:11 - User Defined Java Class.0 - *****************************************************************
2015/12/30 12:15:19 - User Defined Java Class.0 - DWH_CMN_EXCHANGE_RATE - Job Log: 2015/12/30 12:15:19 - dwh_jb_post_execution - Starting entry [ClarityDB - isOracle?]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_jb_post_execution - Starting entry [dwh_tr_post_execution]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ------------> Linenr 1------------------------------
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Running Post Execution for 'DWH_CMN_EXCHANGE_RATE':
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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_CMN_EXCHANGE_RATE';
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - DWH_LOAD_END_DATE = 2015/12/30 12:15:19
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ====================
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Error while running this step!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1432)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatements(Database.java:1538)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:225)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 2 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.w(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.s(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.execute(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1406)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 4 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished reading query, closing connection.
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_jb_post_execution - Finished job entry [dwh_tr_post_execution] (result=[false])
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_jb_post_execution - Finished job entry [ClarityDB - isOracle?] (result=[false])
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - Dispatching started for transformation [dwh_tr_post_execution]
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Get System Info.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ------------> Linenr 1------------------------------
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Running Post Execution for 'DWH_CMN_EXCHANGE_RATE':
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - 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_CMN_EXCHANGE_RATE';
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - DWH_LOAD_END_DATE = 2015/12/30 12:15:19
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - ====================
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Write to log 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Error while running this step!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Couldn't execute SQL: update
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DWH_CFG_AUDIT
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - set
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings),
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - DW_LOAD_END_DATE = to_date('2015/12/30 12:15:19', 'yyyy/mm/dd HH24:MI:SS')
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - WHERE
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - TABLE_NAME='DWH_CMN_EXCHANGE_RATE'
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1432)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatements(Database.java:1538)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:225)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 2 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 -
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.w(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.s(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at com.ca.clarity.jdbc.oraclebase.dde3.execute(Unknown Source)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - at org.pentaho.di.core.database.Database.execStatement(Database.java:1406)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - ... 4 more
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished reading query, closing connection.
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - Execute SQL script 2.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - dwh_tr_post_execution
2015/12/30 12:15:19 - User Defined Java Class.0 - 2015/12/30 12:15:19 - dwh_tr_post_execution - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - User Defined Java Class.0 - null
2015/12/30 12:15:19 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2015/12/30 12:15:19 - 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_CMN_EXCHANGE_RATE
2015/12/30 12:15:19 - User Defined Java Class.0 - at Processor.processRow(Processor.java:64)
2015/12/30 12:15:19 - User Defined Java Class.0 - at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)
2015/12/30 12:15:19 - User Defined Java Class.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/12/30 12:15:19 - User Defined Java Class.0 - at java.lang.Thread.run(Thread.java:745)
2015/12/30 12:15:19 - dwh_etl_interface_dim - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
2015/12/30 12:15:19 - dwh_etl_interface_dim - dwh_etl_interface_dim
2015/12/30 12:15:19 - dwh_etl_interface_dim - dwh_etl_interface_dim
2015/12/30 12:15:19 - dwh_etl_interface_dim - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!