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

Article Id: 51831

Status: Published

Updated On: 26-08-2018 22:26

Legacy Id: TEC522900

Products:

CA Identity Manager , CA Identity Governance , CA Identity Portal , STARTER PACK-CLARITY PPM

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