Skip to Content

JDBC Receiver error

Hi Experts,

I am working on production support using SAP PI 7.1.Getting below error while am monitoring in RWB adapter engine.

Scenario is ECC-JDBC .

Delivering 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. 'RevenuePosting' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 133) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.. Setting message to status failed.

Any help would be appreciated.

Regards,

Shaik

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 30, 2015 at 05:39 AM

    Hi Shaik,

    I think the problem is raised in the DB when two or more process in DB are trying to access to the same resource. Try to increasing the isolation database level Configuring the Receiver JDBC Adapter - Enabling Application-to-Application Processes - SAP Library

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Shaik,

      Try with TRANSACTION_READ_COMMITED or upper. It is better to have the securest option, but for example the Serializable option is only possible if the DB table has this option activated (at least in Oracle).

      Also, i would speak with the DB team that the test the stored procedure with the data that you have passed, may be any table can be locked when another process trying to access it.

      Hope this helps.

      Regards.