Big Data Base Size (not more disk space)

[Former Member]

Hellow Experts (excuseme my not good english)

We have a escenario SAP CRM -> PI -> IBM MQ to procces bussines partners information and replicated on other systems (in real time).

For this, and 3 months ago, we activated the bdocs on CRM (BUPA_MAIN in this case ),and now we have a 4 millons of messages with error "Receiver Determination: No receiver could be determinated"  because not all the type of bdocs we need proccess.

The Data Base of  PI (production) have more than 1.5 TB of this error messages and don't have more disk space and is incresaing for 70,000 messages by day ...

We need delete ALL the error messajes (they don't care/we don't need) from jan 2016 at today.

We have this:

And the tcode "sxi_monitor" we see this:

we need detele this messages to delivery space on the file system .

What can i do?

Thanks in advanced...

[former_member186851 · Accepted solution]

Hello Juan,

Try deleting the messages using the program mentioned in the below link

SAPTechnical.COM - Archiving and Deletion in PI

[Former Member]

Hello Again,

We verify that the BDOC ( CRMXIF_PARTNER_SAVE_M.CRMXIF_PARTNER_SAVE_M03 ) don't have a escenario to be process (and we don't need) .

In CRM in the we20 tocode remove the mapping, with this, PI haven't anymore messages and now execute it all for delete (one step at time) all this "trash" messages.

Thanks.

[former_member186851]

Juan Not getting you.

So the link shared is helpful?

[Former Member]

yes..

Thanks Raghuraman.

[former_member186851]

Cool Juan..:)

Nice to hear.

Close the thread if your query is addressed.