Uncommittable transaction is detected at the end of the batch. The transaction is rolled back

[former_member182455]

Hello experts,

we have developed one interface from ECC to DB ( Data base). while connecting the data we are facing the below issue in the channel.

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. 'spPFSAREInsBulkPFContributionDetails' (structure
'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Uncommittable
transaction is detected at the end of the batch. The transaction is rolled
back.

Kindly help me to resolve the issue.

Thanks in advance.

Regards

srinivas

[RaghuVamseedhar · Accepted solution]

Srinu,

Please try Transaction Isolation Level - 'read_uncommitted' OR Database Auto-Commit-Enabled (No Transaction Handling). Let us know the result.

Configuring the Receiver JDBC Adapter - Advanced Adapter Engine - SAP Library

[former_member182455 · Accepted solution]

Hi Raghu,

Thanks for your replay. I made the required changes as suggested.

Got the Results successfully

Regards

Srinivas

[former_member183908]

check the transaction isolation level option in your receiver JDBC channel and choose the relevant for your case.please go through sap help for more details

Thanks

[pvishnuvardan_reddy]

Hi Srinu,

I think this issue might be due to the more number of messages accessing the same resources on the database. Can you check the below link which might help you on this regard.

How to deal with Warning : "Uncommittable transaction is detected at the end of the batch. The...