Clarity

Hi,

We have installed Jasper soft in the server. We are trying to configure DWH. We have created a DB link in ppm_dwh schema . the link name is "NIKU_DBLINK". When I give this in NSA i am getting error "NSA-0132: Database link could not be created successfully. Please verify the Database and Data Warehouse connection details.

Failed to update properties on the Jaspersoft server. User Id not found" Error.We have created a db link in niku schema as well to connect to ppm_dwh schema.

Any suggestions?

on the database which hosts the Clarity app are you able to connect to this other database?

If not you need to check the permissions and link set up

The manual has a entry about NSA-0132.

"If for some reason the default database link does not work, a custom database link can be created from the Data Warehouse schema."

More information here

https://docops.ca.com/ca-ppm/14-3/installing-and-upgrading/set-up-the-data-warehouse

DB links are working from both the schema. I tested it. But still I am setting same error fin NSA.

HI Arun,

if you have created the DB at the database then in CSA --> under Dataware house you need to check the box Custom Database Link, ( Leave the field unchecked to create a database link. Check the value if you have already created a database link in the database. )

Have you done that and then tried saving. Else it will again try to create the DB link.

Regards

Suman Pramanik

If i select this option I am getting

error

Hi Arun,

This states that DB Link is not there

To verify that PPMDBLINK is working, run the following query from the PPM_DWH schema:

SELECT count(1) FROM PPMDBLINK.niku.niku.srm_resources

If the link works, data is returned.

Regards

Suman Pramanik

I can able to establish the connection b/w DWH and niku schema. When I try to run load data warehouse job I am getting below error

dwh_db_check_ - An error occurred executing this job entry :

Couldn't execute SQL: BEGIN

RPT_CALENDAR_SP();

RPT_INV_HIERARCHY_SP();

END;

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "NIKU.RPT_CALENDAR_SP", line 255

ORA-06512: at line 2

Any suggestions?

Timeslice job has run successfully.

Hi Arun,

This error can happen when  timeslices are not set to first day of the week and that’s the reason not only load data ware house rather Update report tables jobs will fail with the same error .

See the tip by CA PPM Tuesday Tip: How to Set Up the DWH (Data Warehouse) time slices to avoid errors with the 'Update Report Tables' and 'Load DWH' jobs  and set it accordingly.

Regards

Suman Pramanik

HI Suman,

I did change the timeslice settings to first day of the week and ran the timeslice. But the load data warehouse job is still failing and it gives the same error

Can you please share a screen shot of your slice settings.

HI Suman,

I found some of the slices are not configured correctly. Now I have set it right and it started processing.

Thanks Arun,

Hi Suman,

I job got failed error with the below error message

xecute SQL script 2 - org.pentaho.di.core.exception.KettleStepException: Error while running this step!  Couldn't execute SQL: update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date('2015/12/30 11:30:02', 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_CMN_EXCHANGE_RATE'  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01407: cannot update ("PPM_DWH"."DWH_CFG_AUDIT"."DW_UPDATED_DATE") to NULL    at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) at java.lang.Thread.run(Thread.java:745) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: update DWH_CFG_AUDIT set DW_UPDATED_DATE = (select dwh_dim_start_date from dwh_cfg_settings), DW_LOAD_END_DATE = to_date('2015/12/30 11:30:02', 'yyyy/mm/dd HH24:MI:SS') WHERE TABLE_NAME='DWH_CMN_EXCHANGE_RATE' 

We are using only single currency set up. We don't find rows in  CMN_EXCHANGE_RATEs table . Also  dwh_cfg_settings table also returns zero rows.

Hi Arun,

I would need the full DWH log to analyze. Please provide the same.

Regards

Suman Pramanik

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!