Skip to Content
avatar image
Former Member

How to empty all message tables in a SAP PI database

(I apoligize for my poor English)

Hi all:

I need to know how to empty all the tables in the SAP PI database that are related to sending messages and processing them, as if PI had never processed a message.

Is this possible to do? Thanks in advance and greetings,

Alejandro Gómez

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 01, 2017 at 01:40 PM

    Hi Alejandro,

    Please read the sap note 2388483

    Look for XI in Product/Stack column

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2017 at 05:22 AM

    Hi Alejandro,

    If you want to empty(clear) the PI relevant tables, you need schedule the PI delete job to do it.

    e.g. - SAP_BC_XMB_DELETE_<client> (Deletion job for XML messages)

    - SAP_BC_XMB_HIST_DELETE_<client> (Deletion job for history entries)

    If your PI is dual stack, both ABAP and Java, you need schedule the job both on ABAP and Java side, for more details, please refer to the note ##872388 - Troubleshooting Archiving and Deletion in PI . It is the central note for PI table reorganization.

    Regards,

    Liz

    Add comment
    10|10000 characters needed characters exceeded