Unable to save changes to projects - Page Spins

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM On Premise

Issue/Introduction

Users experiencing issues when trying to save changes to projects. The users either get a spinning icon and it can take many seconds or minutes to complete, or it just doesn't do the action at all. This issue may be noticed when attempting to change the project manager on a project and saving.

Example of warning that may be seen in app-ca.logs:

WARN  2019-11-19 08:23:09,675 [http-nio-6025-exec-5] niku.xql2 (clarity:ZZZZZ:ZZZZZ__5555555-5555-5555-9999-AAAAAAAAAAAAAAA:projmgr.projectNewPost) Lock prInsertServiceLock held by user 500000 requested by user 500000

Cause

If there is an environmental disconnect (i.e. database service shutdown, deadlock), the lock may not be removed from the database, resulting in errors when saving projects.

Environment

Release : All Supported Releases

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

For On-Demand Environments, please log a new support case referencing this article to assist in clearing the locks.  

On Premise customers:

Please run the following query (your DBA might have to execute a 'commit' statement after running this delete)

SELECT * FROM PRLOCK WHERE PRNAME = 'prInsertServiceLock'

SELECT * FROM niku.prlock WHERE PRNAME ='~slLock'

If there are any entries in the result set where the prname is "prInsertServiceLock" or  "~slLock", then run the applicable queries below:

DELETE FROM PRLOCK WHERE PRNAME = 'prInsertServiceLock'

DELETE FROM  PRLOCK WHERE prname=~slLock

Once that has run successfully, please run the following query to verify that the lock has been removed.

SELECT * FROM PRLOCK WHERE PRNAME = 'prInsertServiceLock'

          SELECT * FROM niku.prlock WHERE PRNAME ='~slLock'

Additional Information

For a similar issue creating projects see: 25681 - "Error PRJ-07242: Insert operation failed. The system may be too busy. Please retry" Appears when trying to create a project.