Message delay issue

[Former Member]

Hi XIer,

I am experiencing some strange performance issue, we are using JDBC receiver to delivery data to Oracle DB table, and usually the messages insert into DB correctly and quickly, but some time the message will delay in the following step, I got this log in RWB, please comments on this , thank you very much.

<b>13.09.2007 17:05:15 Success Receiver JDBC adapter: processing started; QoS required: ExactlyOnce

13.09.2007 18:14:51 Success JDBC adapter receiver channel JDBC_Receiver_QHD: processing started; party , service ZBS_HPMES_QHD_PRD

13.09.2007 18:21:10 Success Database request processed successfully

13.09.2007 18:21:10 Success MP: leaving

13.09.2007 18:21:10 Success The message was successfully delivered to the application using connection JDBC_http://sap.com/xi/XI/System.

13.09.2007 18:21:10 Success The message status set to DLVD.</b>

[Former Member]

Hi Qi,

ususally this time delay, if not seen every time, can be caused in your remote DB or by "incorrect" deadlock handling of your used JDBC driver.

You might be able to check on the remote DB for deadlock situations, or initiate an SQL trace there, to see of this is a "normal" behaviour or not.

If your XI release is quite old, please check SAP Note 940291 "XI JDBC Adapter: Slow processing for large XML documents".

Best regards,

Silvia