documentumdocumentum-dql

How do you update a locked record in Documentum using DQL?


I'm unable to update the record with DQL due to a lock. Is it possible to unlock the record, update it and lock it again?

I'm running the following code in idql64.exe on the content server.

UPDATE dm_document objects SET keywords = 'D' WHERE r_object_id = '90000000000000001'
GO 

Error message:

[DM_SYSOBJECT_E_LOCKED]error:
"The operation on sysobject was unsuccessful because it is locked by user


Solution

  • I was able to achieve this by updating the r_immutable_flag column.

    UPDATE dm_document(all) objects SET r_immutable_flag = 0 WHERE r_object_id = '90000000000000001'
    GO 
    UPDATE dm_document(all) objects SET keywords = 'D' WHERE r_object_id = '90000000000000001'
    GO 
    UPDATE dm_document(all) objects SET r_immutable_flag = 1 WHERE r_object_id = '90000000000000001'
    GO