JDBC Receiver: 'com.microsoft.sqlserver.jdbc.SQLServerException: The connection is' error in SAP CPI

[Sakshi_T]

Hi,
In my Proxy to JDBC iFlow, I’m encountering a "The connection is closed" error. While some records are successfully inserted into the database, others fail with this error.

I tried increasing the connection timeout and query timeout in the JDBC receiver from 30 seconds to 60 seconds, but the issue persists.

Could you please suggest possible reasons and solutions?

[karthikarjun]

Hi Sakshi_T - Well, you did correct! After increasing the connection time if you still encounter the same error! This notifies to check the payload!

1. Identify on which record the issue persist
2. Remove that record (for testing)
3. Retry with other records

Regards,

Karthik Arjun

SAP BTP and Integration Architect

[Sakshi_T]

Hi, Thank you for your suggestion. I just wanted to ask—could this issue be related to the Cloud Connector or the Database? Based on my observations, the issue doesn’t seem to be related to a specific record. For example, one day we processed 101 jobs/messages from ECC, and 22 failed. On another day, with the same data, 85 jobs failed with the error "Connection reset." Since the failures are inconsistent, I believe the issue might not be data-related. Please share your thoughts on this.

[Sakshi_T]

Hi, the issue has been resolved. It wasn’t related to Integration Suite—most likely it was caused by either the Cloud Connector or the Database.