Postgres/GCP SaaS: Incremental Load DWH Fails On DWH_FIN_PLAN_CRV_FACTS

Products

• Clarity PPM SaaS

Issue/Introduction

The incremental Load DWH job fails with error on table Table: DWH_FIN_PLAN_CRV_FACTS

Error Message: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_FIN_PLAN_CRV_FACTS. function dwh_cast_curve_fct(schema.nk_curve) does not exist

Recommended Troubleshooting Steps
Verify Function Existence: Run the following query to see if the function exists in your database:

SQL

SELECT n.nspname as schema, p.proname as function_name 
FROM pg_proc p 
JOIN pg_namespace n ON p.pronamespace = n.oid 
WHERE p.proname = 'dwh_cast_curve_fct';

Environment

16.4.0

Cause

There is a missing function named: dwh_cast_curve_fct

Resolution

Ask the DBA to run the following query:

SELECT n.nspname as schema, p.proname as function_name 
FROM pg_proc p 
JOIN pg_namespace n ON p.pronamespace = n.oid 
WHERE p.proname = 'dwh_cast_curve_fct';

If the function does not exist, the function will need to be created.