XI Database problem

[Former Member]

Hi All,

I have strange situation in XI Development, My server guys told that Database is full . Tables are

SAPXD2 SYS_LOB0000046998C00020$$ LOBSEGMENT PSAPXD2DB 83.062.784 10382.848 1.454 1- 0

SAPDAT SXMSCLUR TABLE PSAPDAT 48.761.856 6.095.232 864 1- 0

SAPDAT SXMSCLUP TABLE PSAPDAT 21.303.296 2.662.912 440 1- 0

Yesterday i checked the RWB---> ADAPTER Engine level and I seleted this year "all containing errors" I found more than 10000 error messages, I cancel all the messages in Adapter engine level. and i deleted the all cancel messages manually using this this note: 807615.

But still they are not find the free space in Database level.

And also i checked RWB---> Integration Engine level for this year "alll containing errors" I found more than 10000 system error messages, I am n't able to cancel these messages.

How i can delete these error messages from Integration engine,

My retention period is 20 days, I follow the maximum notes.

Please suggest me how we can solve this situation , Thank you very much.

Regards,

Sateesh

[Former Member · Accepted solution]

Hi,

You can delete messages from IE by running report program :RSXMB_DELETE_MESSAGES.

Please note that Only successfully processed messages can be deleted.

For messages with errors or cancelled, you can run the report

RSXMB_CANCEL_MESSAGES.

Also refer this article on archiving and deleting messages:

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c46a236...

Regards,

Divyesh Vasani

[Former Member]

Reorganization is required and I followed the SAP note:872388

[Shabarish_Nair]

it is advised to have proper deletion and archiving of messages in place -http://bit.ly/him3Iz

[Former Member]

Good Morning All,

I Check the report RSXMB_SHOW_REORG_STATUS,

I found the results are:

No of Messages in DB: 910,616

No of Messages in Client : 910,616

No of messsage in client still to be reorganized: 910,616

Archiving status

-

---

Msg not in retension period (can be archived) : 2065

Delete

-

---

Asynchronouw messages not in retention period (can be deleted)-- 9,08012

Asynchronous messages in retention period(cannot be deleted)-- 366

Asynchronous messages without errors to be flagged -786

Synchr. msgs in retension period (cannot be deleted)- 171

-

---

How i can understand this situation, Kindly guide me.

Thank you very much

Sateesh