JDBC Receiver error

[former_member650236]

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

[iaki_vila · Accepted solution]

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.

[former_member650236 · Accepted solution]

Hello Inako vila,

Thanks for the post.

For my JDBC receiver communication channel the isolation level is set default.

I have seen the document of your link for my comm channel what level shall i put.

Regards,

Shaik

[iaki_vila · Accepted solution]

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.