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

No comments:

Post a Comment