PSIBERR_VW

index back

IB Network Monitor Errors


SELECT A.IBTRANSACTIONID , A.IB_SEGMENTINDEX , A.ERRORTIMESTAMP , A.SEQNO , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.IBDATAERRLOC FROM PSIBERR A ,PSAPMSGPUBC2_VW B WHERE A.IBTRANSACTIONID = B.IBTRANSACTIONID

PeopleSoft Field Name Field Type Column Type Description
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
ERRORTIMESTAMP DateTime(26) TIMESTAMP Error Timestamp
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
IBDATAERRLOC Character(254) VARCHAR2(254) NOT NULL Int Broker Error Location
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20