Deleting Duplicate Routings

Duplicate routings can cause problems with Integration Broker messaging. Fortunately PeopleSoft has provided (as of PeopleTools 8.48 anyway) functionality to search for and delete duplicate routings.

This is available under: PeopleTools > Integration Broker > Service Utilities > Service Administration in the Routings tab. The search will find any duplicate routings and allow you to select and delete them.

delete-duplicate-routings.png

Behinds the scenes PeopleCode searches the PSIBRTNGDEFN Integration Broker Routing Definition for any cases where more than one active routing is associated with the same service operation for any local to local routings, any to local routings and point to point routings.

I'm not convinced the code being used is perform the search for duplicate routings is 100% correct.

I also used the following query to identify potential duplicate routings and found some cases that weren't being picked up:

select 
    IB_OPERATIONNAME, 
    VERSIONNAME, 
    SENDERNODENAME, 
    RECEIVERNODENAME,     
    count(distinct ROUTINGDEFNNAME)
from 
    PSIBRTNGDEFN
where 
    EFF_STATUS = 'A'
group by 
    IB_OPERATIONNAME, 
    VERSIONNAME, 
    SENDERNODENAME, 
    RECEIVERNODENAME
having count(distinct ROUTINGDEFNNAME) > 1;

As far as I'm aware anything returned by such a query is a duplicate routing but I could be wrong.

Comments

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License