Monthly Archives: February 2016

Update PeopleSoft routing destination nodes via SQL

PeopleTools 8.52
We had a situation where we needed to update the routing destination nodes in PeopleSoft via SQL instead of doing it in PIA. Only do this if you aren’t using a WSDL with the routing and its going to a JMS queue. The statements must be run in order.


UPDATE PSIBRTNGSUBDEFN SET RECEIVERNODENAME='NEW_NODE_NAME' WHERE ROUTINGDEFNNAME IN (SELECT ROUTINGDEFNNAME FROM PSIBRTNGDEFN WHERE IB_OPERATIONNAME ='DEPT_FULLSYNC' AND RECEIVERNODENAME='OLD_NODE_NAME');

UPDATE PSRTNGDFNPARM SET RECEIVERNODENAME='NEW_NODE_NAME' WHERE ROUTINGDEFNNAME IN (SELECT ROUTINGDEFNNAME FROM PSIBRTNGDEFN WHERE IB_OPERATIONNAME ='DEPT_FULLSYNC' AND RECEIVERNODENAME='OLD_NODE_NAME');

UPDATE PSIBRTNGDEFN SET RECEIVERNODENAME='NEW_NODE_NAME' WHERE IB_OPERATIONNAME='DEPT_FULLSYNC' AND RECEIVERNODENAME='OLD_NODE_NAME';