Cost Plan Details blocking database sessions

book

Article ID: 220857

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

Issue/Introduction

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

NOTE: The issue can also occur on Updating the cost plan as it's caused by SQL Curves

 

Expected Results: No deadlocks occur

Actual Results: A deadlock can occur, impact on database performance as sessions are blocking

Environment

Release : 15.9.2

Component : CA PPM FINANCIAL MANAGEMENT

Resolution

This is DE61974, in review by Engineering

Workaround: Disable SQL Curves on the environment