Very old messages in the database

[rainer_hbenthal]

Hi,

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?

[rainer_hbenthal · Accepted solution]

After implementing Note 960240 i was able to delete/archive 75% of those very old messages. But still i have Messages even back to the year 2005. Not mouch, but i would really like to know why thos emessages are not deleted nor achived?

[former_member334189 · Accepted solution]

Dear Rainer,

in case this issue has not been resolved after following section 5 of SAP note 872388 step by step please open an OSS ticket at BC-XI-IS with reference to this thread. This is because it is almost impossible to identify the root cause for not deleting these messages without having access to them. This definitely exceeds the scope of this forum and should be handled by SAP Support.

Best regards,

Harald Keimer

XI Development Support

SAP AG, Walldorf

[former_member4985]

Hello Rainer,

Message status 003 is a Final status, hence it satisfies on of the prerequisites to delete messages.

Also you said the messages are out of the retention period (because they're very old) and this is

the second prerequisite.

The third and last one is the Adapter status, which shooul be in a final status either, which is the 000.

To do that so, since the messages are in 007 status, run the report SXMS_REFRESH_ADAPTER_STATUS.

For your reference:

#872388 - Troubleshooting Archiving and Deletion in PI

With regards,

Caio Cagnani

[rainer_hbenthal]

As i said in #1, this report to refresh the adapter status is running every day.

[rainer_hbenthal]

Here's one from 2006: Adapterstatus is 7 and Messagestatus is 3, ITFACTION is ARCH.

WRP, STO and DEL archiving jobs are scheduled and running every day without any problems - except that this message is not archived.

MSGUID is 01080020063011DBBE18000255D3C405, completly uninteresting for you, i know, but maybe someone else has a specific question and so i can refind this faster.

[Former Member]

Is that interface is a synchronous one? If so, for more info, synchronous messages are not archived.

[former_member4985]

Hi Rainer,

Perhaps they're not in a Final status.

You may post for us what are the messages and adapter statuses of the

messages as per the reports.

Regards,

Caio Cagnani

[Former Member]

Hi Rainer,

check the SAP Note: 872388 ( Troubleshooting Archiving and Deletion in PI)

Also check the thread:

Thanks,

[rainer_hbenthal]

The note is checked. As i said: all deletion jobs are running, all archiving jobs a are running, the adatapter status is refreshed on a daily basis.

[Former Member]

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

Are the message not archived are sync ?

Check this thread, you would find some more info regarding archiving:

Thanks,

Edited by: Hareenkumar on Dec 16, 2010 1:58 PM