'ODF-0107:Object Definition is locked for updates, please retry' error message.

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

This error message indicates that a Clarity lock has been placed on one of the Studio Objects.
It may or may not be on the object that was currently being updated; it could be a different object.

Environment

Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL
Component:

Resolution

To find out which object has the lock, take a look at the data in the lock table.

For Oracle Database

 

 SELECT *
 FROM PRLOCK
 WHERE PRTABLENAME = 'ODF_OBJECTS'
 AND PRNAME = 'objectUpdate'
 AND PRLOCKEDSINCE < sysdate - .042

 

For Microsoft SQL Server Database

 

 SELECT *       
 FROM PRLOCK 
 WHERE PRTABLENAME = 'ODF_OBJECTS'
 AND PRNAME = 'objectUpdate'
 AND PRLOCKEDSINCE < getdate() - .042

 

If any records are returned, go to the UI and verify that these objects should not be locked.

If the records remain in the PRLOCK table, the next step is to delete the specific PRLOCK records found.  

It should only be used when the record cannot be released through standard application functionality.  

NOTE: Back up the PRLOCK table and test resolution in a non-production environment first.

FOR ON PREMISE IMPLEMENTATIONS ONLY.

For Oracle Database

 

 DELETE       
 FROM PRLOCK 
 WHERE PRTABLENAME = 'ODF_OBJECTS'
 AND PRNAME = 'objectUpdate'
 AND PRLOCKEDSINCE < sysdate - .042
 ;
 COMMIT
 ;

 

For Microsoft SQL Server Database

 

 DELETE       
 FROM PRLOCK 
 WHERE PRTABLENAME = 'ODF_OBJECTS'
 AND PRNAME = 'objectUpdate'
 AND PRLOCKEDSINCE < getdate() - .042
 ;
 COMMIT
 ;

Additional Information

Please have a look to the communities link below to learn more about types of locks:
https://communities.ca.com/thread/241727387