SXMSPMAST - Update Adapter Status field

[jegathees_waran]

Hello Friends,

There are huge no. of acknowledgement messages with adapter status "007" (Message has error state on Outbound Side) and message status "003" (Processed successfully) in the table SXMSPMAST.

Those messages are not considered for reorganization.

We want to update those messages to adapter status "006".

Is there any SAP Standard Program to do this?  (to change all the records those have the value "007" in the field ADAPT_STAT to "006")

Kind regards,

Jegathees P.

[MichalKrawczyk]

Hi,

did you have a look at report section here:

http://wiki.sdn.sap.com/wiki/display/XI/PI+Archiving+Conceptual+Overview

for mass cancellation reports

Regards,

Michal Krawczyk

[jegathees_waran]

Hi Michal

Thanks for your reply.

I have gone through this link already. There is one report for Mass Cancellation : RSXMB_CANCEL_MESSAGES.

This report will cancel error messages only. In our case, for all acknowledgment messages, the message status (MSGSTATE = 3, Table: SXMSPMAST) is 3 i.e processed successfully state but, the adapter status is 7. (ADAPT_STAT = 7). 

The RSXMB_DELETE_MESSAGES job is not considering the messages with ADAPT_STAT = 7 to set the field REORG = 'DEL'. So, when the table switch job is run (RSXMB_TABLE_SWITCH), these messages are not dropped from the table.

For your reference, I have attached the screen shots : SXMB_MONI, Table : SXMSPMAST (Status of ack messages) in gif file.

Kindly let me know if you have any clue.

[jegathees_waran]

Hi Michal,

Sorry my reply was disappeared when I added attachment.

Thanks for your reply.

I have gone through this link already. There is one report for Mass Cancellation : RSXMB_CANCEL_MESSAGES.

This report will cancel error messages only. In our case, for all acknowledgment messages, the message status (MSGSTATE = 3, Table: SXMSPMAST) is 3 i.e processed successfully but, the adapter status is 7. (ADAPT_STAT = 7).

The RSXMB_DELETE_MESSAGES job is not considering the messages with ADAPT_STAT = 7 to set the field REORG = 'DEL'. So, when the table switch is done. (RSXMB_TABLE_SWITCH), these messages are not dropped from the table.

For your reference, I have attached the screen shots : SXMB_MONI, Table : SXMSPMAST (Status of ack messages) in the  thread above.

Could you please check and reply ?

[MichalKrawczyk]

Hi,

have you tried using this one - RSXMB_RESET_ADAPTER_STATUS ?

form

Note 831429 - XI acknowledgment messages cannot be deleted

Regards,

Michal Krawczyk

[jegathees_waran]

Hi Michal

Thank you for your guidance.

This report "RSXMB_RESET_ADAPTER_STATUS" is not available in our PI system (??), though we have higher version.

SAP_BASIS

730

SAPKB73005

I read this note 831429 and downloaded through SNOTE txn in our PI system. When I checked the note, the system says "SAP Note 0000831429 cannot be implemented". (

Note 0000831429 cannot be implemented since no valid correction is available.)

It is surprising why this report is not available. How do we proceed further?