Load DWH Job Fails On Postgres Database Error: Alter Function SET search_path FROM CURRENT

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When running the Load DWH job, the BG DWH log shows:

ERROR 2023-09-01 23:42:00,823 [dwh_jb_prerequisite_pg UUID: 75b0d065-2680-4fa6-8558-e034c4276aef] dwh.event (none:none:none:none) () Set Search_Path - An error occurred executing this job entry : 
Couldn't execute SQL: ALTER FUNCTION prj_effort_fct SET search_path FROM CURRENT;
ALTER FUNCTION dwh_cal_datelabel_fct SET search_path FROM CURRENT;
ALTER FUNCTION prj_max_actthru_fct SET search_path FROM CURRENT;
ALTER FUNCTION prj_sum_assignment_fct SET search_path FROM CURRENT;
ALTER FUNCTION crv_fiscal_calendar_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_calc_finish_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_calc_finish_time_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_cal_date_add_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_cal_startdate_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_days_late_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_days_late_pct_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_start_days_late_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_start_days_late_pct_fct SET search_path FROM CURRENT;
ALTER FUNCTION cop_date_trunc_fct(date) SET search_path FROM CURRENT;
ALTER FUNCTION cop_date_trunc_fct(timestamp with time zone) SET search_path FROM CURRENT;
ALTER FUNCTION cop_date_trunc_fct(timestamp without time zone) SET search_path FROM CURRENT;
ALTER FUNCTION prj_default_alloc_rate_fct(bytea) SET search_path FROM CURRENT;
ALTER FUNCTION crv_read_double_fct(character varying) SET search_path FROM CURRENT;

ERROR: could not find a function named "cop_cal_date_add_fct"

Resolution

In order for function(cop_cal_date_add_fct) to be installed, PMO must be installed with command:
admin content csk