search cancel

Cost Plan Details blocking database sessions

book

Article ID: 220857

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Deadlocks / Performance Issue. We have deadlocked sessions on our database on updating Cost plans (FIN_COST_PLAN_DETAILS)

Steps to Reproduce:  

  1. Create a Cost plan with at least 100 rows 
  2. Setup the TSV for cost, many periods 
  3. Copy/paste a value into > 50 rows 

Expected Results: No deadlocks occur. 

Actual Results: A deadlock can occur which impacts database performance as sessions are blocking. 

The issue can also occur on Updating the cost plan as it's caused by SQL Curves. The code is not optimized to perform the post processing actions.  These actions should be performed at the end of the copy action. 

Environment

Release : 15.9.2, 15.9.3

Resolution

This is DE61974 - Due to the complexity of the proposed 'additional' optimizations related to this specific use case reported here, story work is in the backlog that will be planned for a future release. 

Workaround: Disable SQL Curves on the environment