Info
Content
Books
Integration Broker
Deleting Duplicate Rou...

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 in the Routings tab under:

PeopleTools > Integration Broker > Service Utilities > Service Administration

delete-duplicate-routings.png

The search will find any duplicate routings and allow you to select and delete them.

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 so it might be worth double checking with this query as well. 
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;
No Comments
Partners
Details
Revision #2
Created 3 months ago by PeopleSoft Wiki
Updated 3 months ago by PeopleSoft Wiki
Actions
Export
Back to top