Deadlocks / Performance Issue. We have deadlocked sessions on our database on updating Cost plans (FIN_COST_PLAN_DETAILS)
Steps to Reproduce:
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.
Release : 15.9.2, 15.9.3
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