on 10-10-2007 12:58 PM
Hello,
I set the retention period to 7 days (1 week)
I also set the default ARCHIVE and DELETE jobs and ALL are working fine.
However, messages with OLD dates are NOT deleted from the tables XI_AF_MSG and XI_AF_MSG_AUDIT.
These tables 32GB in the DBD table space.
I tried to use the URL:
http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp
BUT to NO avail.
How do I DELETE or ARCHIVE these messages ?
============================================
Here are some more details on the content of the tables (I took into account 1 MONTH retention):
db2 "select count(*) from sapxi3db.XI_AF_MSG_AUDIT where STATUS='SUCC' and TIME_STAMP < '2007-09-10 00:00:00'"
-
28947
1 record(s) selected.
db2 "select count(*) from sapxi3db.XI_AF_MSG_AUDIT where STATUS='ERR' and TIME_STAMP < '2007-09-10 00:00:00'"
-
13243
1 record(s) selected.
db2 "select count(*) from sapxipdb.XI_AF_MSG where PERSIST_UNTIL < '2007-09-10 00:00:00' and STATUS='NDLV'"
-
1048
1 record(s) selected.
db2 "select count(*) from sapxipdb.XI_AF_MSG where PERSIST_UNTIL < '2007-09-10 00:00:00' and STATUS='DLVD'"
-
0
1 record(s) selected.
Hi,
1. You said that you have used the below URL.
http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp
What error message did yo get.
2. Have you customized any Archiving for adapter Engine or You are using default arciving which runs every 24 hrs.
Check whether the default job is running in Background processing in Commpoent Monitoring in RWB.
3. Have you set the retention period for the adapter engine messages in visual admin in seconds...
SAP XI Adapter :XI
xiadapter.inbound.persistDuration.default
xiadapter.outbound.persistDuration.default
Award points if helpful.
Thanks,
Tanuj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
First, thank you VERY much for answering.
Now to your questions:
1. When using the URL:
http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp
I did NOT get any ERROR messages.
Thousands of messages where DELETED successfully.
However, the number of rows in XI_AF_MSG_AUDIT did NOT reduce.
2. I used the default archiving and deletion customizations and jobs.
However, I ran them manually a few times a day with NO change in the
number of rows in XI_AF_MSG_AUDIT
What do you mean by "customized any Archiving for adapter Engine" ?
. In RWB, I do see the default job is running
Have you customized any Archiving for adapter Engine or You are using default arciving which runs every 24 hrs.
3. I did ser the retention period for the adapter engine messages in visual admin in seconds...
Please, advise further.
Kind regards,
Gil
Hi,
First, thank you VERY much for answering.
Now to your questions:
1. When using the URL:
http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp
I did NOT get any ERROR messages.
Thousands of messages where DELETED successfully.
However, the number of rows in XI_AF_MSG_AUDIT did NOT reduce.
2. I used the default archiving and deletion customizations and jobs.
However, I ran them manually a few times a day with NO change in the
number of rows in XI_AF_MSG_AUDIT
What do you mean by "customized any Archiving for adapter Engine" ?
In RWB, I do see that the default job is running
3. I did ser the retention period for the adapter engine messages in visual admin in seconds...
Please, advise further.
Kind regards,
Gil
Hi,
Fo your question..
What do you mean by "customized any Archiving for adapter Engine" ?
To archive interfaces in the Adapter Framework (AFW), the XML DAS (Data Archiving Store) has to be set up. If no archiving has been set up XML message will be deleted from the AFW by the standard deletion job after a default time of 30 days. You can define which interfaces should be archived via archiving rules.
2. what is the value in seconds for the values in Visual admin.
Thanks,
Tanuj
Hi,
The messages are VERY old.
As you can see from the SELECT statements bellow, there are 28947 messages with SUCCESS status and 13243 messages with ERROR status that are MORE than 1 MONTH old .
Please, advise further.
Kind regards,
Gil
The SELECT statements:
-
db2 "select count(*) from sapxi3db.XI_AF_MSG_AUDIT where STATUS='SUCC' and TIME_STAMP < '2007-09-10 00:00:00'"
-
28947
1 record(s) selected.
db2 "select count(*) from sapxi3db.XI_AF_MSG_AUDIT where STATUS='ERR' and TIME_STAMP < '2007-09-10 00:00:00'"
-
13243
1 record(s) selected.
Hello Gil,
Did you solve your problem ? I have the same problem in my XI.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vivian,
In RWB I did cancel the ERR messages.
Then, I ran the URL
http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp
again and the messages were deleted.
However, I now have problems in the DELETION jobs, as the messages I deleted with the URL were part of an NOT deleted ARCHIVE job. i.e., the DELETION job of these archive session is CANCELED with a message that the messages that are supposed to be DELETED are NOT found in the DB.
Now, NOTHING works.
ALL the archiving jobs say they have NOTHING to archive.
And the DELETION jobs is always CANCELED because of the OLD archive sessions of which messages do NOT exist any more.
Kind regards,
Gil
Hello again,
Should I use:
DELETE FROM XI_AF_MSG_AUDIT WHERE TIME_STAMP < ...
from SAP Note 892394 ?
As the messages from XI_AF_MSG_AUDIT do NOT seem to be deleted NOR archived using the NORMAL jobs ?
Please, advise.
Kind regards,
Gil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.