Cost Plan Details blocking database sessions

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 has been completed and addressed in Clarity 16.1.0.

Workaround: Disable SQL Curves on the environment