Skip to Content
Author's profile photo Deepak Shah

Archiving & Deletion of messages in PI – Part 4

          Part 4 of the blog series explains the steps to be performed for deletion of xml messages in Adataper framework. This will also deal with deletion of BPE workitems. Below are few points to be considered in case of deleting messages from adapter framework. 1.) Only messages in a final status can be deleted or archived.   2.) Messages with errors have to be cancelled first. Manually cancelled messages do not have to be archived but can also be directly deleted in the AFW. Canceling messages in the AFW is done in the RWB via “Message Monitoring”. To find the messages in error choose your adapter engine and either select the Database Overview or the Database page (select status “All Containing errors”). If you have many messages in error you can use the “Multiple Selection” button to cancel messages.   3.) Messages on the Java side are persisted in table *XI_AF_MSG* for PI 7.0 & table *BC_MSG* for PI 7.1). This table cannot be monitored via transaction SE16. Therefore you have to use database tools. To analyze the overall number of messages you could use the following SQL statement: SELECT COUNT (*) FROM XI_AF_MSG.


4.) As a rule only those messages get archived, for which persist until date is expired. Persist until date gets calculated by the current send/receive time of a message, plus the configurable “persist duration” value. For the central and decentral Adapter Engine(s) “persist duration” value can be configured as two properties of the J2EE Service


1.”SAP XI Adapter: XI” (value is in milliseconds): “xiadapter.outbound.persistDuration.default”

2. “xiadapter.inbound.persistDuration.default”


5.) Keep in mind that the default persist time for messages in the Adapter Framework is 30 days. This means that messages will be kept in the database for 30 days until the deletion job removes them. Changing the retention period in the AFW will only affect new messages that get processed by the adapter engine.  


6.)  As of XI 3.0,  SP11, a user interface is available that allows you to manually set the retention time for messages to expired so that you can remove these messages from the database immediately or archive them before deleting them.

For this purpose, call the following URL in a browser   


* * Enter a number of days. For the messages that were sent or received earlier than the number of days you have specified, the retention time is reset so that you can delete them immediately from the database. image Bear in mind that you can only delete or archive messages whose retention time has expired and at the same time, that have, a final status (successful or failed). In addition, only messages without any configured archiving rules can be removed manually from the database. If an archiving rule exists for a message to be deleted, it is deleted automatically after the scheduled (or manually started) archiving job was completed. image 7.) You can check the successful execution of the deletion and archiving jobs via the background processing monitor in the RWB. Enter the RWB, navigate to “Component Monitoring” and click “Display”. Choose the Adapter Engine of your Integration Server host and hit the button *”Background Processing” *  image  *BPE Runtime – Deleting work items: *   1. When you execute receive steps, send steps, transformation steps, receiver determinations and blocks, work items are generated in integration processes in each case. The system may contain a very large number of work items as a result. The table *SWWWIHEAD* has a large number of entries in your system. 2. Messages that are processed by integration processes in work items can have synchronous and also asynchronous origins. Asynchronous messages are already persisted in the integration server and can also be archived from there. Synchronous messages are not persisted. 3.  The question therefore arises as to whether you can delete the work items or whether you must also archive them. In most cases, it should suffice to archive the incoming message and the outgoing message for asynchronous messages, or to archive the outgoing message for synchronous messages in the sending system. If this is insufficient due to legal regulations, the generated work items can also be archived or deleted during message processing. 4.  You can use the report *RSWWWIDE* or Transaction *SWWL* to delete all work items, including all of the attachments and dependent work items. Since the report RSWWWIDE can also delete work items that are not in a final status, it is recommended to make the selection according to the “*COMPLETED*” work item status, the creation date and work item type “*F*”. image 5.  If a large number of work items must be deleted, you may have to restrict the selection criteria by specifying smaller date ranges. Note that if you use the report incorrectly, at worst, all of the work items in the system are deleted. Always run the report in test mode first by not selecting the *”Delete immediately”* checkbox. Once you press F8, all work items having status as ‘COMPLETED’ will be deleted.   image

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.