Delete dm_workflow objects with r_runtime_state=4

Imran_Yusubov

Hello Experts,

In our environment we have about 100 workflows with r_runtime_state=4. According to documentum documentation,

Value    Meaning

0        Dormant

1        Active

2        Finished

3        Halted

4        Failed

Now I want to delete the workflow objects with runtime state 4 but when I try to update the state for them an exception is thrown.

update dm_workflow objects set r_runtime_state=2 where r_runtime_state=4

And the result is,

Error occured during query execution :[DM_QUERY_F_UP_SAVE]fatal:  "UPDATE:  An error has occurred during a save operation."

Please help me to solve the issue.

verinondctm

try this query for update the workflow objects

update dm_workflow objects set r_runtime_state=2 where process_id='4b0000000000000';