Discussion
Cognizant
US
Last activity: 13 Nov 2015 4:16 EST
Deleting one application specific Broken queue records from multiple application Broken queues,all apps running on same server
Hi,
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 .
Thanks!
PEG
IN
If UDF's installed you can use those to delete the Broken-Queue.
Cognizant
US
Thank you gangababu., 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 UDF's ?.
PEG
IN
Please refer https://community.pega.com/support/support-articles/prreadfromstreamerror-occurs-when-trying-fetch-blob.
Cognizant
US
UDF's are there in v7 onwards, in v6.1 UDF's wont help acheive above requirement.
the queue item has no direct reference to the application, so there is no direct way to achieve this requirement with application as a key, however we will use the access group to identify the application indirectly,
- Use an activity to get the list of all the broken items.
- Iterate through each item and check for accessgroup.
- If the access group matches with the access group associated with say Application you want to delete,delete the entry.