Skip to Content

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

JDBC channel error

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

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