TDMS(Technical Document Management System)

Hi All,

There is a dm_queuemanager job, its work is to clean out the dequeued objects . The Job had stopped on 7/11/2012 we have re-started it and it cleared 127,000 objects from dmi_queue_item. But there are still 27000 objects that is not being cleaned up.

We are not sure why it’s not able to clean the left dmi_queue_item objects. When we extract the daily report for the job, we don’t see any issue in the report. PFA the 8/9/2012 report. Could you please help us in identifying the issue (days for which dmi_queue_items are still existing) ?

The query used to identify the undeleted objects is :

Select count(*) from dmi_queue_item where delete_flag=1 and task_name=’event’.

Thanks,

Rajkumar

+917387412643