Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Receiver Adapter with many deadlocks

Hi Gurus !

Hi have many interfaces from Idocs to JDBC inserts to a MS SQL Server 2005. I'm using PI 7.0 SP 18.

I'm having a problem when I send many idocs (with many segments) because some messages stay in waiting, or, to be delivered status at the endpoint in message monitoring. The real message is:

Unable to execute statement for table or stored procedure. 'EQUI' (Structure 'JDBCStatement_EQUI') due to com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

It makes 6 retries, and after the sixth failure it stays in status NDLV. Every time that tries to resend the message it makes the same error (deadlock), I guess because there are many messages that are trying to do the same in same moment.

In the receiver CCs I put the value 50 in the Maximum Concurrency field.

Does anyone know which parameters can I improve this situation? The server hasn't any tunning.

Thanks in advance,

Juan

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question