Discussion
Cognizant
US
Last activity: 7 Sep 2015 6:53 EDT
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
Updated: 28 Aug 2015 9:20 EDT
Pegasystems
IN
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.
Pegasystems
IN
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.
Cognizant
US
but i would like to go with pr_read_from_stream,
how to install UDF's in pega. do we need to install from pega side or Data base side? please let me know the steps to insatll this pr_read_from_stream UDF?
Thank you
PEG
IN
Pegasystems Inc.
US
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
Cognizant
US
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.