cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete sap pi xml messages without archive for particular period

Former Member
0 Kudos

Hello Team, Our requirement is to delete old XML messages permanently without archiving and leave messages for the past 3 months in the system, so that we shall configure delete/archive for the past 3 months onwards.

Could anyone share the procedure in doing so.

Thanks & Regards,

Jayachandra

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks for all your comments. It was really helpful. I have a doubt here. Imagine messages has been archived and deleted from database.

Now I want to retrieve message from archived file, may I ask you, how we can achieve this.

Former Member
0 Kudos
Former Member
0 Kudos

Hi Jayachandra,

Please follow the below steps for deleting the XML logs in PI Systems.

Goto Transaction SE11

Specify the table name: SXMSPMAST and Click Display Button

Find the field Name ITFACTION then Click the contents (or) CTRL+SHIFT +F10

Find the ITFACTION filed again and mention the value 'DEL' and Click the Number of Entries on top of menu.

Now the Total no of delete status messages will be displayed.

Now go to SXMB_ADM

Under Configuration Menu

Define Interfaces for Archiving and Retention Periods and Click on Retention period and Put all the fields as 90 Days as you want to leave 90 days xml messages..

Go back to SXMB_ADM

Under Integration engine

Select Schedule delete jobs

Start date <Today Date>

Start time< Specify the time> and other fields leave it as blank

Now job has been scheduled and check the Job status after run.

Here you can find how many messages has been deleted and check in SXMB_MONI whether the old xml message has been deleted or not.

Kind Regards

Venkat

Former Member
0 Kudos

Thanks Venkat for your help. I have a query here, Before following the steps given by you, I searched for the list of messages in sxmb_moni during year 2011, I could see nearly 18860 in error status.

However, when I search for number of entries in ITFACTION, it shows number of entries as 8050. So, I am confused, what the difference is.

If I follow the above method mentioned you, does it delete automatically error messages as well.

Former Member
0 Kudos

Hi,

Ok. First you please cancel the all failure messages in PI System then follow the delete jobs.

For cancelling the failure messages in PI System,please follow the below steps.

Go to SE38 and give the following function module name RSXMB_CANCEL_MESSAGES and click excute button

Next window will be opened.

Provide the date excute from which date onwards you want to cancel the message and under the other options UNTICK the Test and execute it.

Now all the failure/error messages has been cancelled. Now you are ready to do the schedule the delete jobs in SXMB_ADM and it will delete all the xml messages including failure/cancelled messages in PI Systems.

Thanks..

Kind Regards

Venkat

former_member366655
Active Participant
0 Kudos

Hi Chandran,

Check these links:

https://scn.sap.com/thread/1687208

Thanks ,

Vivek