Create project ‘ERROR System error. Contact system administrator’, 'Cannot insert duplicate key row in object 'niku.INV_HIERARCHIES' with unique index 'INV_HIERARCHIES_U1''
book
Article ID: 98347
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity PPM On Premise
Issue/Introduction
The standard project creation process takes 4 minutes to compile and this causes several errors, especially when we select the standard workflow action known as "Convert Idea to Project".
Steps To Reproduce
1. Go to ‘Home’ -> ‘Projects’ 2. Click on the ‘New’ button to create a project 3. Give it a project name 4. Click on the ‘Save’ button
Expected Result: For the project to be created straight away
Actual Result: The cursor keeps rotating round and after 5 minutes it fails with this error: ‘ERROR System error. Contact system administrator’.
App-ca.log: ERROR 2018-05-23 16:14:06,464 [http-###-##-exec-####] niku.xql2 (clarity:admin:#######__########-####-####-####-############:projmgr.projectNewPost) Internal Processing exception com.niku.union.persistence.PersistenceException: SQL error code: 2601 Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'niku.INV_HIERARCHIES' with unique index 'INV_HIERARCHIES_U1'. The duplicate key value is (<NULL>, #######). SQL error code: 3621 Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
Environment
All versions
Resolution
1. Please remove lock in database by running these statements:-
Select * from niku.prlock where prname='~slLock' Select * from prLock where prname=prInsertServiceLock Delete from prlock where prname=~slLock Delete from prLock where prname=prInsertServiceLock
2. Afterwards, please restart all the CA PPM services via the command prompt using these commands:-