ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DWH Load Failing on DWH_INV_TASK_LN Constraint

book

Article ID: 217293

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The Load Data Warehouse (DWH) is failing with the below error:

Reload Facts? - An error occurred executing this job entry : Couldn't execute SQL: CALL DWH_DISABLE_CONSTRAINTS_SP('DWH_INV_TASK_LN','FK')ERROR: Could not remove FK constraint dwh_inv_task_ln_fk1 on table dwh_inv_task_ln.  Aborting DWH load.  Where: PL/pgSQL function dwh_disable_constraints_sp(character varying,character varying) line 66 at RAISE

Error 4/28/21 9:17 AM 
User Defined Java Class - Unexpected error

Error 4/28/21 9:17 AM 
User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_TASK_LN 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.base/java.lang.Thread.run(Thread.java:834)

Error 4/28/21 9:17 AM 
dwh_etl_interface_dim_pg - Errors detected!

Error 4/28/21 9:17 AM 
ETL Job Failed. Please see log bg-dwh.log for details.

Job Completed 4/28/21 9:17 AM 
NJS-0401: Execution of job failed.

Cause

This is caused by DE60749

Environment

Release : 15.9.1, 15.9.2

Component : CLARITY DATA WAREHOUSE

Resolution

Fixed in 15.9.3 as DE60749

Additional Information

See also Load DWH job frequently reported issues