Skip to Content
author's profile photo Former Member
Former Member

Archive of Records in Table SXMSCLUP and SXMSCLUR

We need to archive the records of the table SXMSCLUP and SXMSCLUR in R/3 4.7, the size of the table is very huge so its having impact while ECC upgrade.

So I searched in forums and came across this thread http://forums.sdn.sap.com/thread.jspa?messageID=3055630#3055630

but I am not sure whether we can use archive object BC_XMB as it is not including the tables.

Also I came across the Note 761713 which is discussing about report used to delete the entries from the tables.

Can anyone provide what is the correct archiving procedure for those two tables in R/3 4.7.

Thanks & Regards,

Sathish

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 07, 2012 at 12:37 PM

    Hi Sathish,

    All asynchronous XI messages are persisted in the database of the integration engine. The SXMSCLUP table you mentioned contains the payloads of these messages, that's why it is so big. And that's why the archiving or deletion of XI messages have to be performed on a regular basis by using the corresponding jobs and the right retention periods and deletion procedure in the integration engine configuration,depending on the data volume exchanged. To be archived or deleted, XI messages have to be in a final state, that are "processed successfully","branched" or "manually cancelled". The problem when you have reached a so high amount of messages in the XI tables is that it will take a lot of time to suppress these messages from the database. One solution for you would be to activate the switch procedure for the deletion. In that procedure mirror tables are used, when the deletion procedure is triggered all the messages which cannot be deleted are copied in the mirror tables, the new messages are also redirected to these mirror tables and the original tables are simply dropped. If you do not have a lot of messages to be copied from the original to the mirror tables then this procedure is much more faster than the standard one. You will find all the required information in the 872388 note.

    Thank You.

    Regards,

    Deepika

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.