Skip to Content
avatar image
Former Member

Error deleting messages in XI_AF_MSG table

Hi experts.

We have reached 100% usage of tablespace which contains tables XI_AF_MSG and XI_AF_MSG_AUDIT.

After doing some research, we have seen that the default job of deleting messages in the adapter engine is not working well. Trying to execute the deletion manually, in the URL http:// server:port /MessagingSystem/archiving/reorgdb.jsp and we get the following error:

com.sap.aii.af.ra.ms.api.DeliveryException: Error removing messages or audit log entries with expired persist duration.

at com.sap.aii.af.ra.ms.impl.core.store.MessageStore.removePersistDurationExpiredMessages(MessageStore.java:851)

at com.sap.aii.af.ra.ms.app.ArchivingBeanImpl.removePersistDurationExpiredMessages(ArchivingBeanImpl.java:314)

at ......

And we don't get any more message. Don't know how to delete some messages.

Thank you all.

IGnasi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 31, 2011 at 04:35 PM

    Hi,

    Did you check defaultTraces of J2EE server nodes? there could be some more information about the failed adpater engine job.

    Is other jobs in adpater engine working fine like the archive or recover jobs

    Also check the PersistDuration set for the adapter engine messages. the parameter is xiadapter.inbound.persistDuration.default in the SAP XI Adpater service. only after this period the messages could be deleted by the deletion job.

    Regards,

    Francis

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2011 at 05:08 PM

    Thank you for your fast reply.

    I have checked default logs and I get the error:

    SQL statement is "DELETE FROM "XI_AF_MSG" WHERE "MSG_ID" = ? AND "DIRECTION" = ?".#5#1654#72000#ORA-01654: unable to extend index SAPXIDDB.SYS_IL0000087335C00020$$ by 128 in tablespace PSAPXIDDB

    Tables XI_AF_MSG and XI_AF_MSG_AUDIT are in the same tablespace. So, I can't delete messages in this tables because the tablaspace is full? Is not possible for us to get some extra space inmediately, nor have access to oracle directly.

    The others jobs, recover is executing ok but not archiving. Gives us a nullpointer exception. There is any way to get free space in that tablespace?

    Thank youuuuuuuuuuuu

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Once you basis team has extended the space, you can clean up your sap system by using Archiving & deletion.

      If you need any information on how to do it, pleae refer this blog.

      /people/deepak.shah/blog/2010/04/22/archiving-deletion-of-messages-in-pi--part-1

      Regards,

      Deepak.

  • avatar image
    Former Member
    Feb 10, 2011 at 02:41 PM

    Finally, we added some extra space in this tablespace and we could make the changes.

    thank you very much!!!

    Add comment
    10|10000 characters needed characters exceeded