How do I delete dm_workflow objects where the document being routed has been deleted?
When this happens, the customer may also report an error from their Consistency Checker report like the following:
Checking for dmi_package objects that reference non-existent dm_workflow objects
Checking for workflow objects with non-existent r_component_id
WARNING CC-0046: dm_workflow object with r_object_id ‘4dxxxxxxxxxxxxxxx’ references non-existent sysobject with r_component_id ‘09xxxxxxxxxxxxxxx’
Fortunately, the solution to this is simple. Simply take the r_object_id of the dm_workflow object and run the following two API:
API>abort,c,<4dxxxxxxxxxxxxxxx>
API>delete,c,<4dxxxxxxxxxxxxxxx>
Repeat this for each ‘corrupted’ dm_workflow object.