Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2015 at 06:21 AM

    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 another process and …

    Regards.

    Add comment
    10|10000 characters needed characters exceeded