Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a 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

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.