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
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.
Release : All Supported Releases
Component : CA PPM INTEGRATIONS & INSTALLATIONS
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'
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.