cancel
Showing results for 
Search instead for 
Did you mean: 

PI message archiving

Former Member
0 Kudos

Hello

I have recently been made responsible for a PI 7.1 system, and am new to SAP and PI. I have some general questions about message archiving and would be grateful for some advice.

I understand that message details are saved to SXMSPMAST and associated tables. There is a limit to the number of rows in the tables.

Q. What happens when the tables are full?

Q. Is it possible to increase the number of rows that they can hold?

I believe that none of our existing interfaces have been configured for archiving/retention.

Q. Should the interfaces have been configured for archiving before first use?

Q. Does this only apply to asynchronous interfaces?

The vast majority of messages in SXMXPMAST have ITFACTION set to 'INIT'. I understand that these messages will not be deleted or archived.

Q. Is it possible to change the ITFACTION and is this something I should be doing?

Q. There are some synchronous messages with a status of system error on our system. I am not able to cancel these messages in SXMB_MONI. I do not want to keep a record of these messages as they were sent before the system was 'live'. Is there anything I can do to delete them?

I have found several documents on the SAP forums and blogs, but none deal with the case where existing interfaces haven't been configured for archiving.

Kind regards

Steve

Accepted Solutions (1)

Accepted Solutions (1)

former_member334189
Active Participant
0 Kudos

The vast majority of messages in SXMXPMAST have ITFACTION set to 'INIT'. I understand that these messages will not be deleted or archived.

No, this is not quite correct. Both values 'INIT' and 'DEL' mean that the message will be deleted.

Q. Is it possible to change the ITFACTION and is this something I should be doing?

A. No, usually this is nothing you have to worry about. Once interfaces for archiving are maintained the system will do this for you. However, using report RSXMB_DEL_TO_ARCH (see above) you can change the interface action.

Q. There are some synchronous messages with a status of system error on our system. I am not able to cancel these messages in SXMB_MONI. I do not want to keep a record of these messages as they were sent before the system was 'live'. Is there anything I can do to delete them?

A. Synchronous messages cannot be canceled. Run report RSXMB_ARCH_INTERFACES -> Retention Periods to configure the period in time to keep synchronous messages in error state. As soon as the message has expired it will be picked up by PI deletion job SAP_BC_XMB_DELETE_<client>.

Best regards,

Harald Keimer

Former Member
0 Kudos

Thank you, Harald, for answering all my questions so thoroughly. I now feel that I have a sufficient understanding of PI message archiving.

For anyone reading this thread in future, I would also recommend 'Mastering SAP Netweaver PI - Administration' from the SAP Press, for an explanation of how to configure archiving and deletion of messages.

Answers (2)

Answers (2)

former_member334189
Active Participant
0 Kudos

Dear Steve,

a lot of questions Let me answer them one by one...

I understand that message details are saved to SXMSPMAST and associated tables. There is a limit to the number of rows in the tables.

Q. What happens when the tables are full?

A. Nothing. The number which you refer to as 'limit of rows' reflects the number of expected entries. This value is used to control reorganizational tasks in PI.

Q. Is it possible to increase the number of rows that they can hold?

A. Yes, but SAP does not recommend this in general. Also there is no need to increase this number as it used as a threshold for reorganization only.

I believe that none of our existing interfaces have been configured for archiving/retention.

Q. Should the interfaces have been configured for archiving before first use?

A. Yes, definitely. The interface action nis determined right when the message enters the Integration Server. Therefore it is important to configure archiving beforehand. However, as of PI7.10 SP6 report RSXMB_DEL_TO_ARCH is available to change the interface action from 'deletion' to 'archiving' belatedly (this direction only!).

Q. Does this only apply to asynchronous interfaces?

A. Yes, synchronous messages will not be archived.

I

Former Member
0 Kudos

Hi steve,

SXMB_ADM transaction can help you archiving the messages.

Try to execute Report: RSXMB_CANCEL_MESSAGES in transaction SE38.

Manisha

Edited by: Manisha Das on Mar 29, 2010 12:59 PM

Former Member
0 Kudos

Hello Manisha

Thank you for the information.

I ran report RSXMB_CANCEL_MESSAGES. It found about 180 messages that could be cancelled - these seem to be messages that had failed but could be manually restarted. It did not include failed messages that could not be restarted, i.e. those that failed with a system error.

That is useful, but what I'm more concerned about is the large number of messages that aren't in a state ready for archiving or deletion.

There are 160,000 messages with a status of INIT; 5000 with a status of DEL; and 26 with a status of ARCH in SXMSPMAST.

Am I right in thinking that the messages with a status of INIT can not be archived or deleted?

When I run report RSXMB_SHOW_STATUS it finds :

165871 messages in database

165871 messages in client

165871 messages for reorganization in client

26 messages to be archived in client

Kind regards

Steve

JaganMohan
Participant
0 Kudos

Dear Steve,

I hope the following wiki will give you the related details.

http://wiki.sdn.sap.com/wiki/display/XI/PIArchivingConceptual+Overview

Regards,

JP.

Former Member
0 Kudos

Hello JP

Thanks for the URL. I had already read that document and found it explains the archiving process better than any other.

However, it doesn't explain what to do about XML messages with ITFACTION of 'INIT'.

We have 150,000 synchronous messages in SXMSPMAST, with a message state of 3 and ITFACTION of 'INIT'. Some of them date back to the time when we first started to use the system.

I understand that synchronous messages aren't archived, so I assume that they should be deleted, but report RSXMB_DELETE_MESSAGES only deletes messages with ITFACTION of 'DEL'.

Should our synchronous interfaces have been configured to mark messages for deletion? Is there anything I can do to mark these messages for deletion now?

Kind regards

Steve