search cancel

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

book

Article ID: 202126

calendar_today

Updated On:

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

Cause

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

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

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