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

Question

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

score 4 · Answer 1 · edited Mar 29 '19 at 12:38

4

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

edited Mar 29 '19 at 12:38

Miki

2,493
2
27
39

answered May 31 '18 at 11:50

Henning Winter

101
4

I've upvoted your answer, but I needed to use the idql64.exe – aduguid Jun 03 '18 at 06:37
1

Just upvoted this answer, and I also say that is possibile not only from DqMan, but also from DA, in Tools > API Tester. – Andrea Jul 17 '19 at 13:38

score 2 · Answer 2 · answered Jun 02 '18 at 05:06

2

Yes, you need to be a member of dm_escalated_allow_save_on_lock group, in this case Documentum will do everything automatically.

answered Jun 02 '18 at 05:06

Andrey B. Panfilov

4,324
2
12
18

Wow, famous Panfilov! And again useful tip! ;) – Miki Mar 29 '19 at 12:39

score 0 · Accepted Answer · answered Jun 03 '18 at 06:36

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

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

Error message:

3 Answers3