Load Data Warehouse Job failure post upgrade to 16.3.1 Broadcom SaaS Only

Products

• Clarity PPM SaaS

Issue/Introduction

Following the upgrade to version 16.3.1 of Broadcom SaaS and the modification of the ODATA service, the Load Data Warehouse job is failing with the following error: "ERROR: must be a member of the role whose process is being terminated or a member of pg_signal_backend."

 

Steps to Reproduce: 

1. Perform a fetch using Clarity Data Warehouse OData Service API's 
2. Observe table pg_stat_activity and there will be session from Clarity Data Warehouse OData Service as idle in transaction 
3. Run the Load Data warehouse job (Incremental/Full) 

Expected Results: The Job Load Datawarehouse (Incremental/Full) instance should complete successfully

 

Actual Results: The Job Load Datawarehouse (Incremental/Full) instance fails immediately with below error stack 

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

Environment

Clarity 16.3.1 Broadcom SaaS Only

Cause

DE168163

Resolution

Fixed in Clarity Data Warehouse OData Service 2.0.0.94. 

The fix will be been implemented in Broadcom SaaS

Additional Information

Note: This particularly impacts customers who uses Data Warehouse OData Service API's