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,
This is under Engineering investigation.