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
[DM_SYSOBJECT_E_LOCKED]error:
"The operation on sysobject was unsuccessful because it is locked by user
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