How to delete 900000 messages at a time in PI.?

[Former Member]

Hi,

We have 900000 lac bad messages in my PI system , from on e of my MDM systems, we want to delete all these messages in one step. Could you please let me know how to delete.

I have gone through the note 872388 too

Could some please help me out,,

Regards,

Ravi Maddela

[former_member200962 · Accepted solution]

Did you go through this discussion:

You need to schedule the delete job.

Regards,

Abhishek.

[Former Member]

thanks for all .. my issue has been solved.

[Former Member]

Those jobs are scheduled as per the schedule ... client did some testing on XI systems .. there were 9 lacs messages were processed and they got cancelled .. we want to delete only these messages related to perticual sender service.. job has been scheduled already ..

Want to delete only perticular service messages...

thanks for response

Regards

Ravi Maddela

[Former Member]

You can cancel messages of a particular service using RSXMB_CANCEL_MESSAGES.

Refer this Blog-

/people/gourav.khare2/blog/2007/12/21/mass-cancellation-of-error-messages--xi

Once the messages are cancelled, you can delete them using report RSXMB_DELETE_MESSAGES.

[Former Member]

Hi Ravi Maddela,

It's possible. Please go through my wiki to perform the your task.

http://wiki.sdn.sap.com/wiki/display/stage/PIArchivingConceptual+Overview

I hope this will solve your issue.

Regards

Sekhar