Load DWH job (Full Load) failed in PROD with deadlock error

Products

• Clarity PPM SaaS

Issue/Introduction

The scheduled full load of load DWH job failed this morning with the below error. Can you please review and let us know what is the issue and how it can be fixed

Environment

Release : 16.0.3

Resolution

When running Full Load we never recommend running reports as you also risk reporting wrong data in addition to poteantial deadlock if one of the tables being used by the report is also being attempted to truncate by the job.

Deadlocks is hard to predict meaning same resource at that given time should be used by both processes which does not happen all that often but again it is a possibility.

With respect when 2 reports running at the same time, nornally with 2 select queries we don't see deadlock, ususally it's when exclusive lock is required which normally with update/truncate/delete and so on but not for select.