ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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. Schedule the Time Slicing job  to run every minute
  2. Run other jobs, such as Run a Process, that run custom scripts every minute 
  3. Alternatively, do 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

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