meesages are not getting deleted using reorgdb in single stack

[jayat]

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

[fatihyar]

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

[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

[Former Member]

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

[jayat]

Hi Gaurav,

Thank you for your reply.

We have kept the persistant duration as 30 days. But after the duration also messages are not getting deleted.

But now we are trying to delete th messges directly from reorgdb url. We are not able to delete the messages that are expired. It gives error as "0 messages deleted sucessfully".

http://host:port/MessagingSystem/job/reorgdb.jsphttp://sappjq:50000/MessagingSystem/job/reorgdb.jsp

Regards,

Jaya