Showing posts with label Integration Broker. Show all posts
Showing posts with label Integration Broker. Show all posts

Monday, 21 July 2014

Synchronous App Message Error Status SQL


If you have turned on Logging in your Service Operations -> Routings, you can run these sql statements to get the Error details.

  • select * from psibloghdr where STATUSSTRING = 'ERROR' order by PUBLISHTIMESTAMP desc
  • select * from psiblogerr order by ERRORTIMESTAMP desc
  • select * from psiblogerrp order by ERRORTIMESTAMP desc

To see the explanation for message no., Run

  • select * from PSMSGCATDEFN where message_set_nbr = 158 and message_nbr = :1

You can see this information from online page


PeopleTools -> Integration Broker -> Service Operations Monitor -> Synchronous Services