AnsweredAssumed Answered

Load Data Ware House job is failing Post 14.3 Patch 10 Installation

Question asked by RKP on Apr 14, 2018
Latest reply on May 24, 2018 by varun.chopra.2

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
------------------------------------------------------------------------------------------------------------------------

Outcomes