XI_AF_MSG

[Former Member]

Hello,

Does anyone know the structure of table XI_AF_MSG? I need to query the database in order to get error messages in Adapter Engine.

Thanks

Pedro Leal

[Former Member]

Hi Pedro,

Here is the structure of XI_AF_MSG table...

Name Null? Type

-

---

-

---

MSG_ID NOT NULL NVARCHAR2(119)

DIRECTION NOT NULL NVARCHAR2(8)

REF_TO_MSG_ID NVARCHAR2(254)

CONVERSATION_ID NVARCHAR2(254)

SEQUENCE_NBR NUMBER(10)

CONN_NAME NOT NULL NVARCHAR2(80)

MSG_TYPE NOT NULL NVARCHAR2(4)

STATUS NOT NULL NVARCHAR2(4)

TO_PARTY_NAME NOT NULL NVARCHAR2(60)

TO_PARTY_TYPE NOT NULL NVARCHAR2(120)

FROM_PARTY_NAME NOT NULL NVARCHAR2(60)

FROM_PARTY_TYPE NOT NULL NVARCHAR2(120)

TO_SERVICE_NAME NOT NULL NVARCHAR2(60)

TO_SERVICE_TYPE NOT NULL NVARCHAR2(80)

FROM_SERVICE_NAME NOT NULL NVARCHAR2(60)

FROM_SERVICE_TYPE NOT NULL NVARCHAR2(80)

ACTION_NAME NOT NULL NVARCHAR2(120)

ACTION_TYPE NOT NULL NVARCHAR2(80)

DELIVERY_SEMANTICS NOT NULL NVARCHAR2(4)

MSG_BYTES BLOB

SENT_RECV_TIME TIMESTAMP(6)

TRAN_DELV_TIME TIMESTAMP(6)

SCHEDULE_TIME NOT NULL TIMESTAMP(6)

PERSIST_UNTIL TIMESTAMP(6)

TIMES_FAILED NUMBER(10)

RETRIES NUMBER(10)

RETRY_INTERVAL NUMBER(19)

MSG_PROFILE NOT NULL NVARCHAR2(40)

TRANSPORT NOT NULL NVARCHAR2(40)

ADDRESS NVARCHAR2(254)

CREDENTIAL NVARCHAR2(254)

TRAN_HEADER NCLOB

VALID_UNTIL TIMESTAMP(6)

NODE NOT NULL NUMBER(10)

ERROR_CODE NVARCHAR2(127)

ERROR_CATEGORY NVARCHAR2(64)

PP_USER NVARCHAR2(128)

PP_HASH BLOB

VERS_NBR NOT NULL NUMBER(10)

VERS_CREATE_USER NOT NULL NVARCHAR2(128)

VERS_CREATE_DATE TIMESTAMP(6)

VERS_CREATE_TYPE NOT NULL NVARCHAR2(1)

VERS_CREATE_SOURCE NVARCHAR2(254)

VERS_WAS_EDITED NVARCHAR2(1)

- Pinkle

Message was edited by:

Pinkle Naik

[Former Member]

Hi Pinkle,

Do you know where can i find additional information related to this issue? I need to know the different possible values for field STATUS. I need to get all messages with status TO_BE_DELIVERED.

Thanks,

Pedro Leal

[aashish_sinha]

Hi,

Check out the fields

STATUS NOT NULL NVARCHAR2(4)

and

PERSIST_UNTIL TIMESTAMP(6)

This will help u in finding the Status TO be Delivered.

regards

Aashish Sinha

PS : Reward points if helpful

[Former Member]

Hi Pedro,

If you are looking for message with status "To be delivered" then you need to look into Integration engine.

Use SE11 to browse the table SXMSPHIST with message status (MSGSTATE) = 29.

- Pinkle

[prabhu_s2]

simply execute the T.C se11 and provide the table name to view its strucutre.

[Former Member]

Prabhu,

XI_AF_MSG is a table on the Adapter Engine (Java Stack), therefore I cannot see its structure executing se11.

Thanks

Pedro Leal