This report RSXMB_SHOW_STATUS provides an overview of the distribution of message status values of all PI messages of a client in a table container. For messages with the final message status 003 Processed Successfully, the distribution of the adapter status values is output.
The output can also be broken down by pipeline and reorganization status.
Prerequisites
To execute this report, your user must be assigned the following authorization:
Object: S_XMB_AUTH
SXMBAREA: MESSAGE
ACTVT: 03 or 02
This authorization is included in the role SAP_XI_ADMINISTRATOR_ABAP as standard.
Execution
The interface of the report consists of the following blocks: Container, Status, Table Overview, and Enhanced Criteria
Container
Specify which table container you want to evaluate. The PI persistence has two table containers for storing messages. If you have defined the switch procedure as the deletion procedure for the persistence layer, the containers are used alternately.
You can select the following:
- Current Container:
- The system automatically selects the container currently being used.
- Container 1:
- The first container (leading table: : SXMSPMAST) is evaluated, regardless of whether this container is currently being used by the persistence.
- Container 2:
- The second container (leading table: SXMSPMAST2) is evaluated, regardless of whether this container is currently being used by the persistence.
In the default setting, the messages of the current container are checked.
Status
Specify the status values that you want an overview of:
- Message Status:
- The distribution of message status values of all messages in the selected container of a client is output.
- Adapter Status:
- The distribution of the adapter status values is output for all messages in the selected container of a client with the message status 003 Processed Successfully.
Table Overview
Select which additional overviews to output:
- Message Overview:
- The total number of messages is displayed for reorganization actions that yet to be executed and those already executed. For more information, see the Result section -> Overview Block.
- Table Overview:
- The number of entries in the client is output for each database table of the selected container.
Enhanced Criteria Block
If you select the Enhanced Criteria checkbox, an additional frame opens where you can select the following evaluation options:
- Evaluation for Client:
- In this input field you define which client the evaluation should be performed for.
- Pipeline ID:
- If you select this option, the distribution of the message status values and adapter status values is broken down by pipeline ID.
- Reorganization Status:
- If you select this option, the distribution of the message status values and adapter status values is broken down by reorganization status.
Result
The output is divided into the following blocks: Overview, Message Status, Adapter Status, and Table Overview.
Overview Block
This section is output if you selected the Message Overview option during entry:
- Number of messages in the database (cross-client)
- Number of messages in the client
- Number of messages for reorganization (client-specific)
- Number of messages to be archived (client-specific)
- Number of logically deleted messages (client-specific)
- Number of archived and logically deleted messages (client-specific)
Message Status Block
This section is output if you selected the Message Status option during entry: The number of messages in the selected container of a client is output for each message status value 000 – 030 and 100 – 130. The output is broken down by pipeline ID or reorganization status, depending on which option is selected in the Enhanced Criteria.
Adapter Status Block
This section is output if you selected the Adapter Status option during entry: The number of messages is output for all messages in the selected container of a client with the message status 003 Processed Successfully and each adapter status value 000 – 010. The output is broken down by pipeline ID or reorganization status, depending on which option is selected in the Enhanced Criteria.
Table Overview Block
This section is output if you selected the Table Overview option during entry. The total number of table entries in the client is output for each table of the selected container:
- Master table (SXMSPMAST/SXMSPMAST2)
- Enhanced master table (SXMSPEMAS/SXMSPEMAS2)
- Version table (SXMSPVERS/SXMSPVERS2)
- Error table (SXMSPERROR/SXMSPERRO2)
- Property table (SXMSCLUP/SXMSCLUP2)
- Resource table (SXMSCLUR/SXMSCLUR2)
Evaluation
There are usually cluster points for one or more of the following groups in the distribution of the status values:
- Message status 001, 009, 012, 016:
- Messages scheduled by the PI runtime for asynchronous processing in qRFC. Processing of these messages may need to be restarted or canceled manually.
- Message status 003:
- Successfully processed messages. In order to be deleted or archived, the messages need the final adapter status 000 or 006.
- Message status 014, 017, 018, 023-025:
- Messages whose processing was stopped due to errors Processing of these messages must be restarted or canceled manually.
- Message status 021:
- Message whose processing has been canceled manually. These messages must be archived.
- Message status 029:
- Messages that have been transferred to the Business Process Engine (BPE). These messages are released by the BPE for deletion or archiving.
For more information about the actions required for a successful reorganization of PI messages, see SAP Note 872388.
