Hi Everyone ,
The Load Data Ware house job is failing after patch 10 installation on Clarity 14.3 version .
We tried it running it from many a times and the log error is different every time . Please advice .
First time Run Error -
Post execution - org.pentaho.di.core.exception.KettleException: Unexpected error during job metadata load Unable to load the job from XML file [file:///opt/clarity/apps/clarity/META-INF/datamart/etl_scripts/dwh_population_dim\..\dwh_cmn_etl_jobs\dwh_jb_post_execution.kjb] Unable to get VFS File object for filename 'file:///opt/clarity/apps/clarity/META-INF/datamart/etl_scripts/dwh_population_dim\..\dwh_cmn_etl_jobs\dwh_jb_post_execution.kjb' : Could not find file with URI "/opt/clarity/apps/clarity/bin/file:/opt/clarity/apps/clarity/META-INF/datamart/etl_scripts/dwh_population_dim\..\dwh_cmn_etl_jobs\dwh_jb_post_execution.kjb" because it is a relative path, and no base URI was provided. at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1179) at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1136) at org.pentaho.di.job.entries.job.JobEntryJob.execute(JobEntryJob.java:576) at org.pentaho.di.job.Job.execute(Job.java:678) at org.pentaho.di.job.Job.exe
User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_FIN_TRANSACTION 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)
dwh_etl_interface_dim - Errors detected!
-------------------------------------------------------------------------------------------------------------------------------
Second time run error -
User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_ODF_XYZ_UNIT_ACT_DET_00 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)
dwh_etl_interface_dim - Errors detected!
dwh_db_check_ - An error occurred executing this job entry : Couldn't execute SQL: DECLARE TYPE DIM_REC IS RECORD (CLARITY_CREATED_DATE DATE, CLARITY_UPDATED_DATE DATE, CLRT_XYZ_UNIT_ACT_DETAIL_KEY NUMBER(30), ID VARCHAR2(90), NAME VARCHAR2(240), XYZ_ACTUAL_UNITS NUMBER(32, 6), XYZ_COORDINATE VARCHAR2(60), XYZ_COUNTRY_CAPTION VARCHAR2(2100), XYZ_COUNTRY_KEY NUMBER(32), XYZ_DEPT_CAPTION VARCHAR2(2100), XYZ_DEPT_KEY NUMBER(32), XYZ_FORECAST_RECORD VARCHAR2(180), XYZ_REGION_CAPTION VARCHAR2(2100), XYZ_REGION_KEY VARCHAR2(255), XYZ_UNIT_ACT_DETAIL_KEY NUMBER(30), XYZ_UNIT_ACT_HEADER_KEY NUMBER(32), XYZ_UNIT_NAME VARCHAR2(3000), dw_updated_date date); TYPE ARRAY IS TABLE OF DIM_REC; l_data ARRAY; l_cursor SYS_REFCURSOR; V_SQL_TEXT VARCHAR2(32000); BEGIN CMN_SAVEDROP_CREATE_INDEXES_SP('DWH_ODF_XYZ_UNIT_ACT_DET_00','SAVE_DROP'); V_SQL_TEXT := 'select CLARITY_CREATED_DATE, CLARITY_UPDATED_DATE, CLRT_XYZ_UNIT_ACT_DETAIL_KEY, ID, NAME, XYZ_ACTUAL_UNITS, XYZ_COORDINATE, XYZ_COUNTRY_CAPTION, XYZ_C
-------------------------------------------------------------------------------------------------------------------
Third time run error -
User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_TEAM 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)
dwh_etl_interface_dim - Errors detected!
dwh_db_check_ - An error occurred executing this job entry : Couldn't execute SQL: TRUNCATE TABLE DWH_INV_TEAM [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
-----------------------------------------------------------------------------------------------------------------------
Fourth time run error -
dwh_db_check_ - An error occurred executing this job entry : Couldn't execute SQL: BEGIN DWH_CFG_PRE_CONFIG_SP( P_DBLINK => 'PPMDBLINKDR.XYZI.COM', P_FULL_RELOAD => 'Y' ); END; [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "PPM_DWH.DWH_CFG_PRE_CONFIG_SP", line 19 ORA-06512: at line 2
------------------------------------------------------------------------------------------------------------------------