Cost plan updates via REST API cause deadlocks

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Deadlocks occur on Cost plans with REST API updates when a high number of segments are updated through REST API.

This is reproducible both via REST API and process with REST API

STEPS TO REPRODUCE:

1. Create a process that updates cost plan details with REST API and high number of segments being updated at once
2. On a lower environment run the process just once

Expected Results: The cost plan details to be updated correctly and successfully

Actual Results: Deadlocks in logs ORA-00060: deadlock detected while waiting for resource

ERROR 2024-03-25 11:52:10,879 [http-nio-1621-exec-711] utils.PlanUtils (clarity:admin:ccccccccccccc:PPM_REST_API) (ef187bb4-6244-424d-8c92-5a8796d978da) 
SQL error code: 60
Error message: ORA-00060: deadlock detected while waiting for resource

Executed:
 update FIN_COST_PLAN_DETAILS
        set percentage = (CASE WHEN NVL(?,0) = 0 THEN NULL ELSE total_cost / ? END)
        where FIN_COST_PLAN_DETAILS.plan_id = ? 

 

Resolution

This is DE80094. After further investigation by engineering it has been determined additional work needs to be done and the issue has been converted to a user story so the addition work can be scoped.