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:
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.
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