Posted: 28 Aug 2015 8:53 EDT 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
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 .
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.