Receiving cost plan locked error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Users receive an error that the cost plan that they are trying to load is locked. This happens quite frequently, on different projects, for different users. Modern UX is being used.

Environment

Release : 16.1.2

Cause

A process that would run every 5 minutes, with about 15 UPDATE statements on the fin_cost_plan_details table, which was causing a lock to be held at the DB layer, for the OOTB functionalities of the application.

Resolution

Use XOG or REST API to make updates to cost plans and their details. Direct updates on out of the box tables is not recommended, or supported.