documentumopentextdocumentum-dql

How do I clear up Documentum rendition queue?


We have around 300k items on dmi_queue_item

If I do right click and select "destroy queue item" I see the that row no longer appears if I query by r_object_id.

enter image description here

Would it mean that the file no longer will be processed by the CTS service ? Need to know if this would it be the way to clear up the queue for the rendition process (to convert to PDF) or what it would it be the best way to clear up the queue ?

Also for some items/rows I get this message when doing the right click "destroy" thing, what does it mean ? or how can I avoid it ? Not sure if maybe the item was processed and the row no longer exists or is something else. enter image description here


Solution

  • dmi_queue_item table is used as queue for all sorts of events at Content Server. Content Transformation Service is using it to read at least two types of events, afaik.

    According to Content Transformation Services, Administration Guide, ver. 7.1, page 18 it reads dm_register_assets and performs the configured content actions for this specific objects. I was using CTS for generating content renditions for some objects using dm_transcode_content event.

    However, be carefull when cleaning up dmi_queue_item since there could be many different event types. It is up to system administrators to keep this queue clean by configuring system components to use events or not to stuff up events that are not supposed to be used.

    As per cleaning the queue it is advised to use destroy API command, though you can even try to delete row using DELETE query. Of course try to do this in dev environment first.