Full Load DWH job fails with error calling 'CALL DWH_FIN_PLAN_SUM_FACTS_LOAD'

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Full Load Data Warehouse (DWH) 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

Full error message below:

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

Environment

Release : 15.9.3, 16.0.0 

Component : CLARITY DATA WAREHOUSE

Cause

DE62736

Resolution

Resolved in 16.0.1 and in 16.0.0 Patch #1 (16.0.0.1) 

Workarounds:

1. Run the Full Load DWH again and it will be successful.
2. Schedule runs of the Incremental Load DWH frequently, so the impact is mitigated until a fix is created. 

Additional Information

Also see KB Full Load DWH fails with "must be a member of the role whose process is being terminated or member of pg_signal_backend"