search cancel

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

book

Article ID: 252775

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse Full Load continuously fails with error: 

ERROR 2022-10-16 22:40:42,931 [dwh_etl_master_pg UUID: dd125c36-cafc-40bc-8824-af0e332ac1a2] dwh.event Pre-Execution Config PG - An error occurred executing this job entry :
Couldn't execute SQL: CALL DWH_CFG_LONG_RUN_QUERY_SP();
CALL DWH_CFG_POP_HISTORY_SP();
CALL DWH_CFG_TRUNCATE_TABLE_SP('DWH_CMN_ERROR_MESSAGE');
CALL DWH_CFG_PRE_CONFIG_SP('Y');
CALL DWH_CFG_FOREIGN_TABLES_SP();
UPDATE DWH_CFG_SETTINGS SET ENABLE_PLAN_ACTUALS = 0;
ERROR: must be a member of the role whose process is being terminated or member of pg_signal_backend
  Where: SQL statement "SELECT pg_terminate_backend(v_pid)"

Environment

PostgreSQL and On Premise

Resolution

1. Please provide the following additional permissions to both users clarity and ppm_dwh:

GRANT pg_signal_backend TO <user name>;

2. Then try again.