Deletion of payloads from the Generic Adapter staging table

To delete unnecessary message payloads stored in the staging table, you can use the feature of the administration transaction /INT4/IFTT_ADMIN.

Run the transaction /INT4/IFTT_ADMIN. Then, in the “Administration Mode” section, type “GA_DELETE_STAGING” in the Administration Mode field and specify the processed date of the messages that need to be deleted:

IFTT Test Execution Report - Administration Mode

Execute the report. You will be prompted to confirm that you want to execute this operation:

Once you confirm, you will be informed about the number of selected messages, according to your date selection criteria. Finally, you will be asked to confirm again that you want to proceed with the delete operation:

When you confirm, the selected payloads will be deleted from the staging table. Relevant information will be presented on the results screen.

It is recommended to schedule this report, for example, monthly as a background job, to keep under control the staging table volume.

© 2017 - 2022 Int4 AG All rights reserved