CENTRAL_BACK error messages in Table SXMSPHIST

[mateen_popatia]

Hi,

In table SXMSPHIST there are 3643 history messages of type CENTRAL_BACK. I want to delete these messages. All these messages are in system error status (I cross checked from message monitoring in Runtime workbench). However these messages are not seen in SXMB_MONI. So there is no way I can cancel these messages manually. I ran the report RSXMB_CANCEL_MESSAGES but still no use. Can anyone please tell me How can I remove these CENTRAL_BACK messages from table SXMSPHIST? This is urgent as the DB table is growing quickly.

Thanks.

[mateen_popatia]

Hi Akshay Jamgaonkar,

I cannot reward you any point as the solution which you gave does not help.

Regards,

Mateen.

[Former Member]

Hi,

Try out this one.

create archive jobs in SXMB_ADM to archive data which is XX days old from XI

related growing tables like SXMSCLUR, SXMSPEMAS, SXMSPHIST, SXMSPMAST, SXMSPVERS, SXMSPFRAW ,SWWWIHEAD. This archive job creates archive files at the OS Level. Then a delete job deleted the entire archived data.

refer this links

http://help.sap.com/saphelp_nw04s/helpdata/en/cd/20bc3ff6beeb0ce10000000a114084/frameset.htm

Check this- May be useful also

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c...

Regards,

Akshay Jamgaonkar.

• Reward points if find useful.

Message was edited by:

Akshay Jamgaonkar