Menu
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
249
How do you set the documentum repeating attribute? Well this can be done by executing query or DFC code. Here is the sample DQL query to update the repeating queries. Note: If you do not specify the attribute index in the query by default it will be updated at zero index and old value will be replaced with new value.
Documentum Query Language(DQL) is a derivative of SQL which can be used to interact with Documentum repository. DQL is used to query Documentum which is a content management system used to create, manage, deliver, and archive all types of content.
You have to either unlock it by API, user interface or reset the attributes r_lock_owner and r_lock_machine. I would prefer using API or user interface. API command is
unlock,c,{object id}
and it can be easily scripted.
The issue is caused by a checkout - the user which is stated in the property above.
dqMan from FME is your friend!
Br, Henning
96
Yes, you need to be a member of dm_escalated_allow_save_on_lock group, in this case Documentum will do everything automatically.
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
