How to read the XI queue?

[Former Member]

Hi Experts,

Is it possible to read the XI queue and extract the message payload and store the xml in a ABAP field in XI?

OR

Where do the messages in the queue get stored in XI ABAP tables?

Thanks,

Shobhit

[Former Member · Accepted solution]

Hi,

Even the Messages are Strucked in Queues also, those msgs are available in MONI and stored in Database tables

XI message is actually stored in different tables,

SXMSPMAST, SXMSPMAST2 XML Message master Table, contains runtime information on XML messages processed by XI; in this table you can find all the information that is visible in SXMB_MONI.

Regards

Seshagiri

[Former Member · Accepted solution]

Thanks Seshagiri,

I am actually looking for the XML Payload and not the queue details. Is there a table which stores the actual xml payload of all messages in the queue.

Thanks,

Shobhit

[Former Member · Accepted solution]

Hi,

you have to use abap object to read the payload, you can use for instance method READ_MSG_ALL of class cl_xms_persist.

I suggest you to have a look at my tutorial: [ Massive proxy errors monitor|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/massive%2bproxy%2berrors%2bmonitor]

Kind Regards,

Sergio

[Former Member]

hi shobit,

check these tables

1. SXMSPMAST: (Integration Engine: Message Queue (Master)

2. SXMSPEMAS: (Integration Engine: Enhanced Message Queue (Master)

regards

kummari

[Former Member]

Thanks Seshagiri, Sergio, Kummari!!