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
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.
Release : SAAS
Component : CA PPM SAAS TIME SLICING
The deadlock defect DE58053 on PRTEAM is resolved in the 15.9.1 release.