Clarity

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  Load Data Ware House job is failing Post 14.3 Patch 10 Installation

    Posted 04-14-2018 02:13 AM

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



  • 2.  Re: Load Data Ware House job is failing Post 14.3 Patch 10 Installation
    Best Answer

    Posted 04-15-2018 03:38 AM

    Hi All , This job is running fine from today . 



  • 3.  Re: Load Data Ware House job is failing Post 14.3 Patch 10 Installation

    Posted 05-23-2018 11:20 AM

    Hi,

    Would you please share how you resolve it?



  • 4.  Re: Load Data Ware House job is failing Post 14.3 Patch 10 Installation

    Posted 05-24-2018 03:32 AM

    Hi Varun, 

    Please see if the Jasper Server Application install drive  has enough space available. For me , deletion of  some log files from  Jaspersoft folder worked .



  • 5.  Re: Load Data Ware House job is failing Post 14.3 Patch 10 Installation

    Posted 05-24-2018 03:36 AM

    Thanks, RKP.

    I haven't try that but will let you know if I face it again.