Time Slicing job is failing due to deadlock errors on prteam intermittently

book

Article ID: 210609

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The Time Slicing job is failing due to deadlock errors on several tables intermittently.  This happens approximately once every 2 days. 

PDTSTATEMENT:  UPDATE PRTEAM
                        SET prAllocSum = $1, odf_pralloccurve = $2
                        WHERE prID = $3
PDTERROR:  deadlock detected

STEPS TO REPRODUCE:

  1. The Time Slicing job scheduled to run every minute
  2. Other jobs, such as Run a Process, run every minute that runs custom scripts 
  3. Alternatively, a user could be doing a bulk copy/paste into TSV Per-Period columns which trigger instant time slicing 

Expected Results: Time Slicing job runs regularly without Deadlock errors. 

Actual Results: Time Slicing job runs regularly WITH Deadlock errors. 

Cause

DE58053 (occurring on PRTEAM)

Environment

Release : 15.8.1, 15.9

Component : CLARITY TIME SLICING

Resolution

Resolved in the 15.9.1 release as DE58053 (occurring on PRTEAM)

Workaround: The job will be successful the next time it runs. 

Additional Information

If the above is not the cause of your issue, see also: Time Slicing job failures - troubleshooting / known causes