Messages that do not yet have a final processing status exist in the database. However, these messages were manually deleted from the queue. These messages cannot be deleted and, therefore, remain in the database.
In the system, messages were scheduled in queues. However, you do not want these messages to be processed. Therefore, you delete the queue entries for the messages. The system does not process messages without queue entries. But you cannot delete messages which, according to their status, are still in process. This is not possible because the ‘Quality of Service’ is guaranteed ‘Exactly once’.
To delete these messages, you must terminate their processing. To do this, you can use the report RSXMB_CHECK_MSG_QUEUE. This report searches for messages that are still in processing, but do not have queue entries. You can then cancel the messages that are found by the report.
Prerequisites
To execute all functions of this report, your user must be assigned the following authorization:
- Object: S_XMB_AUTH
- SXMBAREA: MESSAGE
- ACTVT: 02
This authorization is included in the roles SAP_XI_ADMINISTRATOR_ABAP and SAP_XI_MONITOR_ABAP by default.
Execution
The report contains the following parameters:
- Search time frame
- If you want the system to use this parameter, you must specify both the beginning and the end of the time frame.
- Message ID
- You can select all the messages or you can specify a list of messages.
- Pipeline ID
- ID of the pipeline in Integration Engine, that is to be checked.
- Message status
- List of statuses that have to be checked. You must select at least one status.
- Sender system
- Receiver system
- Sender interface
- Receiver interface
- Sender namespace
- Receiver namespace
- Test Run
- If you set this parameter, the system does not delete the messages found, and only displays them.
Result
Once the report has been executed, it provides a list of messages to be cancelled. If executed with “Test Run” checked, the list is only displayed.
If “Test Run” is unselected, the result list contains messages already updated. In the last two columns the result for updating can be seen. This result could be success, or description in case of error, for each XI message.
Recommendations:
- Reduce the number of messages as much as possible by using the time frame or by specifying the message ID and the pipeline ID. These fields have an index and are, therefore, more effective for the search.
- Set the parameters ‘Test Run’ and ‘Display Log’ and check the selected messages. When you have done this, reset the parameter ‘Test Run’ and cancel the selected messages.
