Delete Investments and Time Reporting Periods job failing with deadlock on ODF_ITEM_POSITIONS table

book

Article ID: 242281

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

A large environment with over 30,000 investments and a relatively large number of records in the Picklist item positions table is causing the 'Delete Investments and Time Reporting Periods' job to fail with deadlocks. 

Prerequisites: 

  1. Large environments with 30000 plus investments 
  2. Large number of records in the ODF_ITEM_POSITIONS table 

Steps to Reproduce: 

  1. Mark some investments for deletion 
  2. Execute the 'Delete Investments and Time Reporting Periods' job 

Expected Results: Job should successfully complete. 

Actual Results: Job fails with deadlock error on "something happened while cleaning up picklists". 

Cause

DE64438 

Environment

Release : 15.9.3, 16.0.0, 16.0.1, 16.0.2 

Component : Clarity Project Management

Resolution

Targeted Fix in Release 16.0.3