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.

Full Load Data Warehouse job failed CALL DWH_FIN_PLAN_SUM_FACTS_LOAD();ERROR: Could not remove FK constraint dwh_fin_plan_sum_facts_fk3

book

Article ID: 226264

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Full Load Data Warehouse is failing with the error below.

CALL DWH_FIN_PLAN_SUM_FACTS_LOAD();ERROR: Could not remove FK constraint dwh_fin_plan_sum_facts_fk3

b Started 30/09/21 2:00 AM
 
Message 30/09/21 2:00 AM
Executing ETL Job.
Error 30/09/21 3:13 AM
Fin Transactions? - An error occurred executing this job entry : Couldn't execute SQL: CALL DWH_FIN_PLAN_SUM_FACTS_LOAD();ERROR: Could not remove FK constraint dwh_fin_plan_sum_facts_fk3 on table dwh_fin_plan_summary_facts.  Aborting DWH load.  Where: PL/pgSQL function dwh_disable_constraints_sp(character varying,character varying) line 66 at RAISESQL statement "CALL DWH_DISABLE_CONSTRAINTS_SP('DWH_FIN_PLAN_SUMMARY_FACTS','FK')"PL/pgSQL function dwh_fin_plan_sum_facts_load() line 70 at CALL
Error 30/09/21 3:13 AM
ETL Job Failed. Please see log bg-dwh.log for details.
Job Completed 30/09/21 3:13 AM
NJS-0401: Execution of job failed.

Environment

Release : 15.9.3

Component : CLARITY DATA WAREHOUSE

Resolution

This is being worked under defect DE62736

Additional Information

Workaround:

Run the Full Load DWH again and it will be successful.

Schedule runs of the Incremental Load DWH frequently, so the impact is mitigated until a fix is created