on 09-30-2015 6:17 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.