Posted by Cynthia Rachel
October 15th, 2008

The following query is useful to get the error message return by the Application Message for this you need to give the IBTransacationid as an Input (where as Pub ID in version below 8.48). You can get this id from Message monitor.

SELECT A.MESSAGE_SET_NBR, A.MESSAGE_NBR, B.MESSAGE_TEXT

FROM PSIBERR A, PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR AND A.IBTRANSACTIONID =:1 ORDER BY A.MESSAGE_SET_NBR, A.MESSAGE_NBR DESC

Comments (0)