JDBC channel error

[Former Member]

Hi Experts,

I am working on SAP PI 7.31.

Interface details:

interface pulls details from SAP for Production order , based on a triggered production order number every 20 mins and sends the info to a local SQL server DB.

We are getting below error in JDBC receiver channel and the messages failing with the error

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. '<tablename>' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 55) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. '<tablename>' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 55) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

This is happening whenever their is multiple PO number triggered at a time.

Please help to resolve the same.

Thanks,

Pavi

[iaki_vila]

Hi Pavi,

You must contact with the DB team because the issue is not related con PI, the problem is in the stored procedure, the huge load process or DB configuration. Check with the basis team this link SQL SERVER &amp;#8211; Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with ...

Regards.