Load DWH Job Fails with Deadlock Attempting To Drop Foreign Table dwh_sec_global_right_v

Products

• Clarity PPM SaaS

Issue/Introduction

Couldn't execute SQL: CALL DWH_CFG_POP_HISTORY_SP();
TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE;
CALL DWH_CFG_PRE_CONFIG_SP('Y');
CALL DWH_CFG_FOREIGN_TABLES_SP();

ERROR: deadlock detected
  Detail: Process 28526 waits for AccessExclusiveLock on relation 5173868 of database 16642; blocked by process 28826.
Process 28826 waits for AccessShareLock on relation 17133 of database 16642; blocked by process 28526.
  Hint: See server log for query details.
  Where: SQL statement "DROP FOREIGN TABLE dwh_sec_global_right_v CASCADE"
PL/pgSQL function dwh_cfg_foreign_tables_sp() line 14 at EXECUTE

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Cause

The Load DWH Access Rights is attempting to run at the same time as the Load DWH job.

Resolution

Set the Load DWH Access Rights job as incompatible with the Load DWH job.