Discussion
Deleting one application specific Broken queue records from multiple application Broken queues,all apps running on same server
I have multiple applications running on one server, Sytem-Queue-DefaultEntry conatins all application Broken item, in that I want to delete one application specific broken items from pr_sys_queues DB table with out exposing ‘pxapplication’ name from Blob, any suggestions
If UDFs are installed you can use that. Note that the performance will be really slow
select * from <data_schema>.pr_sys_queues where pyItemStatus = 'Broken-Process' and <data_schema>.pr_read_from_stream('.pxApplication', pzInsKey, pzPVStream) = '<application_name>'
change it to delete if you are getting the right data.
Not that I can think of at the DB level.
You can always write an activity to Obj-Browse (or run report definition) to get all records which are "Broken-Process”, check for pxApplication value in each record and delete the record which matches if column exposure is not allowed.
Sudheer,
I don't have an answer for your specific question, but I'd ask why you have so many and have you addressed the root cause? The broken queue should be used when something unexpected happens to track down and fix the problem with your application and to clean up the error. The queue should stay small and an administrator should be able to do the investigation and delete the items manually if you check regularly. If the queue is full enough that you need a way to mass clean it up, something must have gone wrong and hopefully has already been addressed.
Thanks,
Mike
Thanks for your suggestion Mike,
we analyzed and Broken-Queue for one application(app1) and fixed it, so more broken queues from app1,so here we are deleting old app1 broken queues, but we should not delete other apps(app2,app3..etc) broken queue since prod support team analyzing those.