Skip to Content
author's profile photo Former Member
Former Member

Messages are NOT deleted from tables XI_AF_MSG and XI_AF_MSG_AUDIT

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2007 at 06:10 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2007 at 05:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 07:21 PM

    Hello Gil,

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

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.