Skip to Content
Dec 16, 2010 at 12:13 PM

Very old messages in the database



i just made a copy of the report RSXMB_SHOW_STATUS (this report takes verlong because he is firing a lot select count(*) against SXMSPMAST) and refined the report a little bit to see a time distribution of message- and adapterstatus.

i'm faciong that i still have messages from 2006, 2007, 2008, 2009 and 2010 in the system.

The retention period is 14 days. The delete job, delete history job, archiving job, aggregation job is running on a daily schdule. the report SXMS_REFRESH_ADAPTER_STATUS is running on a daily schedule, too.

The number of messages is not a huge one, approximatly 10.000 per year.

i'm just wondering why these messages cant be deleted/archived? Ich some of them up und checked them in SXI_MONI, i cant see any error and they cant be cancelled.

What other possibilities are there that those messages are not deleted? How can i get rid of them?