Skip to Content
avatar image
Former Member

meesages are not getting deleted using reorgdb in single stack


Hi Experts,

Currently we are working on sap pi 7.31 single stack. We started the system clean up task and checked the default delete job configured in nwa. But always it shows the same count of messages and log doesn't shows any errors.

So we thought of removing the messages using the reorgdburl. We are able to get the list of expired messages from the QA server(56,385 messages have been succesfully expired). When tried to remove those messages it gives "0 messages have been succesfully removed from the database".

Please help us how to get those messages deleted from the database.

Regards,

Jaya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 19, 2015 at 11:06 AM

    Hello ,

    The default delete job should work as expected. Have you checked with your basis team on same?

    Also check the properties of properties of J2EE service "XPI Adapter: XI" - xiadapter.inbound.persistDuration.default and xiadapter.outbound.persistDuration.default. in NWA.

    Also check if this link helps:

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2016 at 06:07 AM

    Hi Jaya,

    We have same situation in our PI system. Did you find a solution to this "0 messages have been succesfully removed from the database" problem.

    Thank you,

    Fatih

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi!

      We had a similar problem...

      You can't remove any (expired) messages with reorgdb.jsp, if they match some archiving rule.

      So first of all check your Archive Jobs: NWA > Background Job Processing Monitor > Adapter Engine Jobs. If you find active Jobs - remove or deactivate them and try to start reorgdb again.

      PS: in our case we have removed all Archive Jobs and just after that reorgdb started to work properly.

      Best regards

      Artem