Delete Job (RSXMB_DELETE_MESSAGES) is not deleting ack messages

[jegathees_waran]

Hello Friends,

In our PI system, there are huge number of ack messages received from application system. In SXMB_MONI, in 'Status' column, it shows "Processed successfully", but in the 'Ack. Status' column, it shows as "Corresponding message was cancelled".

A) This kind of messages are stored in SXMSPMAST table as below:

PID - CENTRAL_BACK

MSGSTATE - 3

QOSMODE - EO

ADAPT_TYP - IDOC

ADAPT_STA - 7   (Message has error state on Outbound Side)

ITFACTION - DEL

ADAPT_TP_I - IENGINE

ACK_STATE - 90 (?)

REORG - INI

These messages are not deleted when the 'RSXMB_DELETE_MESSAGES' jobs run regularly.

B) Whereas the normal ack messages are deleted. It has the status in SXMB_MONI 'Processed Successfully' and in 'Act. Status' column it shows 'No errors in ack'.

Those messages are stored in the SXMSPMAST table as below.

PID - CENTRAL_BACK

MSGSTATE - 3

QOSMODE - EO

ADAPT_TYP - IDOC

ADAPT_STA - 6   (Message executed successfully on outbound side)

ITFACTION - DEL

ADAPT_TP_I - IENGINE

ACK_STATE - 72 (?)

REORG - INI

When we compare the A and B messages, the only difference is in the fields : ADAPT_STA, ACK_STATE. We don't understand the values for field ACK_STATE. The domain for this fields contains the value range 001-009 only.

Could you please clarify how to delete A messages from the table SXMSPMAST.

Kind regards,

Jegathees P.

[Former Member]

Dear Jagathees

Please check in SXMB_ADM -> Schedule Delete Jobs and run after specifying a time.

Let me know if it is deleting the messages in the table

[jegathees_waran]

Hi Sourabh,

Yes, we scheduled it. The job (SAP_BC_XMB_DELETE_120) is not deleting these messages. Why it is not deleting? That's the question. We are checking.