Clearing JDBC queues

[Former Member]

Hi,

We have a scenario where the source system has send 1 lakh + messages and they are struck in the JDBC receiver queues and the processing to the target system is very slow. These messages have been blocking other interfaces from running for days together. We had to stop the channel to allow other messages to be processed.

Now, we want to delete all the messages in this adapter queue and send other required messages. is there any way to clear messages in the adapter queues?

Thanks & Regards,

Sailaja.

[Eoin_Kierans]

Hello,

Can you check the following blog:

XI[XI/PI File and JDBC Receiver Adapter performance and availability improvements|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12338] [original link is broken] [original link is broken];

This describes methods to increase the number of threads for thespecific adapter queues to help with throughput, but also in your case you should check the section detailing note #1136790 'Blocking receiver channel may affect the whole adapter type'. This details how you can limit the number of threads one specific adapter can use so that other messages from other scenarios can also process.

Eoin

[Former Member]

Hi All,

We did not want the messages to flow as it was blocking all the available JDBC threads. We left the channel running and tried cancelling as many messages as we can. Few messages got processed successfully and few got cancelled.

Our issue is resolved for now. So, closing the thread.

Thanks & Regards,

Sailaja.

[Former Member]

Hello Sailaja,

The best way to clear them is to select the messages from Adapter Engine-->RWB and cancel them. But it the message count is really high, you can check with Basis Team, for the SAP PI DB Table that is holding this data. If you clear that DB table records, the messages disappear from you AE view. They can either do this manually or can run a report.

Please try this and let us know if it works or not.

Cheers,

Jack Krugmann