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

Products

• Clarity PPM SaaS

Issue/Introduction

SUMMARY: 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

Cause

 

 

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. 

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

Environment

Release : SAAS

Component : CA PPM SAAS TIME SLICING

Resolution

The deadlock defect DE58053 on PRTEAM is resolved in the 15.9.1 release.