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

Document ID : KB000051831
Last Modified Date : 27/08/2018
Show Technical Document Details
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.

Instructions:

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