DWH Load Job Failed: ERROR: FATAL: terminating connection due to administrator command server closed the connection unexpectedly

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Load data warehouse job fails last night with the error message listed below.

 

Load Facts PG - An error occurred executing this job entry : Couldn't execute SQL: CALL DWH_X_PLAN_ACT_PER_FACTS_LOAD(P_LAST_LOAD_DATE => to_timestamp('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss')::timestamp, P_CURRENT_DIM_LOAD_DATE => to_date('2023/04/05 20:00:32', 'yyyy/mm/dd HH24:MI:SS')::timestamp);

ERROR: FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Where: remote SQL command: COMMIT TRANSACTION PL/pgSQL function dwh_x_plan_act_per_facts_load(timestamp without time zone,timestamp without time zone) line 111 at COMMIT

Resolution

• Check with your DBA to see if there were any database outages or issues at the time of the failure.
• The error indicates the database killed the connection.