cancel
Showing results for 
Search instead for 
Did you mean: 

Messages are NOT deleted from tables XI_AF_MSG and XI_AF_MSG_AUDIT

gil_halevy
Explorer
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

gil_halevy
Explorer
0 Kudos

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

gil_halevy
Explorer
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

HI,

I got your question .. I am not sure why the entries are not getting deleted. There is a TIMESTAMP field in that table. See how old messages are there..

Thanks,

Tanuj

gil_halevy
Explorer
0 Kudos

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.

Former Member
0 Kudos

Hi,

In RWB , Do you leave the messages in SYSTEM ERROR State or you cancel the messages which have been to SYSTEM ERROR.

If it is in SYSTEM ERROR those messages cannot be archived.

Thanks,

Tanuj

gil_halevy
Explorer
0 Kudos

Hi,

Thanks for the info.

1) What about the 28947 messages with SUCCESS status that are MORE than 1 MONTH old ?

2) How do I cancel the messages with the ERROR status ?

Will I be able to Archive/Delete them after I cancel them ?

Kind regards,

Gil

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Gil,

Did you solve your problem ? I have the same problem in my XI.

Thanks

gil_halevy
Explorer
0 Kudos

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

gil_halevy
Explorer
0 Kudos

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