Here are the two options.
1. Restore the dmi_queue_item_s table.
2. All running workflows are useless without the queue item. You will never be able to reach them again. If this is fine we can remove the relationship between the workflows and their queue_items and you can uninstall the wf template again. These workflows should be terminated afterwards to remove them from the system.
a. Run this SQL query to remove the relationship
update dmi_workitem_s set r_queue_item_id = '0000000000000000' where r_queue_item_id <> '0000000000000000' and r_queue_item_id not in (select r_object_id from dmi_queue_item_s)
b. The workflow templates can now be uninstalled.
c. Clean up the repository by terminating all the workflows that are missing dmi_queue_items.
It is not recommended to delete rows from the database that Documentum uses. If you need to delete something, do it through Documentum Administrator or DFC.
1. Restore the dmi_queue_item_s table.
2. All running workflows are useless without the queue item. You will never be able to reach them again. If this is fine we can remove the relationship between the workflows and their queue_items and you can uninstall the wf template again. These workflows should be terminated afterwards to remove them from the system.
a. Run this SQL query to remove the relationship
update dmi_workitem_s set r_queue_item_id = '0000000000000000' where r_queue_item_id <> '0000000000000000' and r_queue_item_id not in (select r_object_id from dmi_queue_item_s)
b. The workflow templates can now be uninstalled.
c. Clean up the repository by terminating all the workflows that are missing dmi_queue_items.
It is not recommended to delete rows from the database that Documentum uses. If you need to delete something, do it through Documentum Administrator or DFC.
No comments:
Post a Comment