Archiving & Deletion XI 3.0/ PI 7.1 - Need Help

[Former Member]

Hi All,

I have configured the Archiving / Deletion settings in both Xi 3.0 & Pi 7.1. I had gone through the documentation from SAP Help & also the Step-by-Step Guides, Blogs, FAQs.

Brief Information abt my settings,

- Done the technical settings of the Archiving objects (Logical File name, Logical path.... etc)

- Done the Interface/ retention period settings etc..

I was able to do the archiving /deletion also, for many msgs. & also read them from Archive.

The main issue is, I am unable to archive/delete some msgs, which I expect to be Archived/deleted.

Cos these are exactly the interfaces I have given in the settings & these are well outside the retention period and they are successful Async msgs.

I could see them in SXMB_MONI (with similar input data as given in A/D settings).

When I run the Archiving job, it creates an empty run without archive file etc.

I am puzzled by the intermittent working of this set-up (I had been testing earlier and many msgs were archived), now I have narrowed down to couple of interfaces & trying to see the Archiving for them.

Is there any overall setting controlling this?? pls help.

Thanks

Knowledge Quest

[Former Member · Accepted solution]

Hi,

Perhaps report RSXMB_SHOW_STATUS or RSXMB_SHOW_REORG_STAT will give you more

information. Iu2019m wondering specifically about the Adapter Status at the bottom of the report RSXMB_SHOW_STATUS. You can directly take a look at the ADAPT_STAT values from table

SXMSPMAST for the messages in question.

If you see 001 or 008, then you will need to schedule report SXMS_REFRESH_ADAPTER_STATUS to run (SAP Note 872388). If you see 007, you may need to resolve the errors first.

Thanks,

-Russ

[Former Member · Accepted solution]

Hello Russell,

Thanks for the info.. I had a look at some of these reports already..

but they dont relate anything to the situation.

for ex. the RSXMB* reports give counter on the number of msgs in different status..nothing specific

however, i think I can get some info from SXMSPMAST ,since it is based on msg id..

but how to relate the issue (as like u mentioned adapter status)

abt adapter reports, I dont think that anything is strange in this area as well..

To put it simple, the transaction is an aysnc checkered flag trans in MONI...nothing different

I shall check the system tomorrow and keep you posted..

meanwhile if you can throw some more light on relating the indications of the above (or any other) reports to the issue it would be great...

Thanks again

Knowledge Quest

[Former Member · Accepted solution]

Hi,

I just wanted to point out that the Message Status can show successful (003- checkered), but the

Adapter Status can keep the messages from being archived/deleted. This may not be your issue at all,

but it was for me recently.

If you get stuck, one thing which also helped me was to see the actual SQL queries which were being

executed when I ran the jobs. Use ST05 with a Trace Filter. Look for queries against the SXMSPMAST table. You should be able to see why your messages are not being picked up. Hereu2019s an example for a delete action query from our XI system. You can see that both the message state and adapter state have to match the criteria.

11794,110 SXMSPMAST  FETCH       0   1403
                                                             
SELECT WHERE "MANDT" = '020' 
	AND "MSGSTATE" IN ( 003 , 020 , 010 , 022 , 023 , 024 , 021 , 011 ) 
	AND ( "ADAPT_STAT" = 006 OR "ADAPT_STAT" = 000 ) 
	AND "ITFACTION" = 'DEL' 
	AND "MSGTYPE" = 'A' 
	AND "EXETIMEST" <= 20080917033327 
	AND "EXETIMEST" >= 0 
	AND "REORG" = INI

Thanks,

-Russ

[Former Member · Accepted solution]

Hello Russ,

Thanks so far.. I hope that I can proceed further from here...

Regards

Knowledge Quest

[Former Member]

I have changed the ARCHIVE_GLOBAL_PATH to my data server. Do I need to change also the ARCHIVE_GLOBAL_PATH_WITH_ARCHIVE_LINK?

thanks

M

[Former Member]

Hi there,

I have Achiveing for my XI system, I have changed the standard pfad for the archive in SARA -> Customising -> Pfad... I run the Archive job, and it makes a .ARCHIVE file in my folder, but then the archiving jobs gets aborted and the log view says: Fehler beim Zugriff auf die Archivdateien - Could not read the Achive files...

Does anyone have an idea what is wrong? I cant eve see the archives in Statistics, or read them... In SXMB_MONI there are no archived messages, but in my folder are about 40 GB of ARCHIVE files...

Thanks for advice...

M

[former_member334189]

Dear Knowledge Quest,

Russell is perfectly correct. The reports RSXMB_SHOW_STATUS and RSXMB_SHOW_REORG_STATUS he has mentioned provide an overview for all XML messages in XI persistency layer. The crucial point here is the fact that only a very limited number of status values allow archiving of messages.

Also the OSS note 872388 mentioned by Russell is the right way to nail this down. This note lists most of the issues that prevent messages from archiving/deletion. Please walk through that note step by step to identify the root cause.

In case you use the Business Process Engine (BPE) you might also want to have a look to OSS note 1042379 which describes reorganizational steps for BPE messages. As the inbound pipeline for BPE uses the XI persistency layer this interferes with archiving/deletion in XI.

Best Regards,

Harald Keimer

XI Development Support

SAP AG, Walldorf