How to check the processed data for archieved messages in sap pi

[Former Member]

Dear all,

1. which tables in sap pi stores the data processed in PI

2. where will we find the archived messages (DATA but not LOGS)

3. As table size increases rapidl, how to schedule a background job to delete the table entries which were older than 30 days

Regards

Sushant

[former_member183379 · Accepted solution]

Dear Sushanth,

Welcome to scn,

For all your query, check "SARA" tcode for answer. In standard, We have pre defined archiving objects (Usually names starts inital 2 letters of module and main table or process like PR_Order).

There are different tabs available (check screen below) in SARA, Explore each for more information.

For tables/object identification - use "Database tables" Tab (tcode DB15).

For Archived data, check "Spool" (green icon beside logs)

There is option to schedule tasks in Preproc, Write and Delete tabs.

Hope it helps.

reg,

Bhg

[former_member184720]

Hi Sushant - There are numerous blogs on archiving and deletion in PI.

Refer the below wiki.. it lists the tables that contains messages.. process to archive and delete them..

Troubleshooting for Archive and Delete on Integration Engine - Process Integration - SCN Wiki

PI Archiving Conceptual Overview - Process Integration - SCN Wiki