Load DWH Job Fails Intermittently After Stuck on DWH_INV_PROJECT
search cancel

Load DWH Job Fails Intermittently After Stuck on DWH_INV_PROJECT

book

Article ID: 245531

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Run either the full or incremental Load DWH job.

Actual: The job gets stuck processing.

Expected: The should complete within 30 minutes

The job intermittently fails after 100+ minutes, where typically it runs in under 30 minutes.

BG-DWH log shows stuck on:
Present?]
INFO  2022-07-06 12:45:14,957 [Thread-13387] dwh.event (none:none:none:none) dwh_dim_load_pg - Starting entry [Track Deletions]
INFO  2022-07-06 12:45:15,176 [Thread-13387] dwh.event (none:none:none:none) dwh_dim_load_pg - Starting entry [Clear Deleted Records ]
INFO  2022-07-06 12:45:15,503 [Thread-13387] dwh.event (none:none:none:none) dwh_dim_load_pg - Starting entry [Merge - Insert/Update ]

Eventually it will fail with 
FATAL: terminating connection due to administrator command
  Where: SQL statement "INSERT INTO DWH_INV_PROJECT (TEST, CLARITY_CREATED_DATE,TEST1, EV_RPT_PERIOD, SPONSORED_BY, PR_USERTEXT1, PR_USERTEXT2, PR_USERTEXT3, PR_USERTEXT4, 

Resolution

This is under Engineering investigation.