Table SXMSPMAST - Remaining entries

[Former Member]

Hi experts,

I have launched report RSXMB_DELETE_MESSAGES in order to delete entries in SXMSPMAST with an 'ITFACTION' = 'DEL'.

It worked fine, but I still have many entries left with 'DEL' status that won't get deleted.

Most of the entries left have MSGTYPE = A, QOSMODE = EO and MSGSTATE = 3.

Do you have an idea why there are still entries left with ITFACTION = DEL after having launched RSXMB_DELETE_MESSAGES.

Any help would be greatly appreciated.

Thanks a lot,

Jamal

[MichalKrawczyk · Accepted solution]

Hi,

there actually are tons of things that can affect deletion

and all of them are described in OSS note: Note 872388 - Troubleshooting Archiving and Deletion in PI

can you please have a look at it first ?

Regards,

Michal Krawczyk

[Former Member]

Thanks a lot to both of you

Actually Michal, I think it comes from this from the note :

Check if there are message with missing qRFC entries. This happens if a user deletes queue entries using transaction SMQ2 instead of (correctly) canceling messages via transaction SXMB_MONI. Messages without queue entries can neither be restarted, nor deleted or archived. SAP has delivered a report to help you cleaning up this type of message status. Please use the report that is described in detail in Note 688147. Keep in mind that deletion of qRFC entries is not recommended at all in an SAP environment. It creates inconsistencies between the tables TRFCQIN and TRFCQSTATE / TRFCQDATA and the XI tables SXMSPMAST which causes the problems for archiving / deletion. Use Note 779664 to check for inconsistencies in the tRFC tables.

So I prefer not to touch since not recommmended

Thanks again,

Jamal

[Former Member]

Hi Jamal,

Check this links

http://help.sap.com/saphelp_nw04/helpdata/en/0e/80553b4d53273de10000000a114084/content.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c46a236...

Regards

Ramesh