PI 7.31 Single Stack. Database Reorganization

[javier_alcubilla]

Hi all

We need to reorganize the database to delete all expired messages (in final status delivered or failed)

¿From where we can apply the reorganization in java stack?

Thanks in advance

Javi

[AnilDandi · Accepted solution]

Hi Javier,

The background jobs on Java stack can be run from pimon

SAP note  872388 is the main note to help deal with cleanup.

As you already know, only the messages in the final status (successful or cancelled) can be deleted/archived. Make sure you reprocess/cancel messages in error or hold status.

If you would like to release messages that are still withing retention period, you can do so from http://<server>:<port>/MessagingSystem/job/reorgdb.jsp. It will only mark the final messages eligible for archiving/deletion, the archive/delete jobs must be run to cleanup.

You might also want to consider SAP notes 2014949 (Removing orphan audit log entries), 2130173 (Optimization of Delete background job) and 1894034 (Audit logs not removed for expired sync logged messages).

regards

AKD

[former_member209420]

Hi Javi,

You can use the following link to manually reorganise your database.

http://<server>:<port>/MessagingSystem/job/reorgdb.jsp

Please consult note https://service.sap.com/sap/support/notes/872388 - Troubleshooting Archiving and Deletion in PI (section 3) for information on configuring your system.

Liam

[former_member184720]

If you have scheduled the delete jobs on AE, it should automatically delete the expired messages.

However if it is a development instance you can do that from (not advisable on production system)

http://host:port/ MessagingSystem/ job/ reorgdb.jsp