Troubleshooting a 'Connection Reset' error with SQL Server 2014

Question

We have an installation of IBM Business Process Manager (BPM) backed by SQL Server 2014. BPM is a Java-based stack, so we are using the Microsoft JDBC driver to connect to the database.

Recently, we are encountering an error when performing deployments of a specific application on the BPM side. The error message is this:
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

We did some debugging on the BPM side, and found that the error is associated with a batched-insert operation. It seems to write some of the data to the target table, but then breaks off suddenly with the above error.

My question is this - how should I go about debugging this on the SQL Server side? I'm not the owner for this specific DB and I'm not a DBA, but I've been asked to look into this.

I've looked at the SQL server logs (exported as per these instructions: https://www.veeam.com/kb2125), but it did not have any entries at the time of the error.

I've looked at the docs for the SQL Server Profiler and the Extended Events mechanism, but I'm not sure if these are the right tools for the job.

Any advice would be appreciated.

Answer 1

Hi thajudheenta,

Welcome to Microsoft Q&A.
In addition to using SQL Server profiler, you can try to use Performance Monitor or use Wireshark to filter capture on port 1433 to see if it is a network issue.
Please refer to Use PerfMon to Diagnose Common Server Performance Problems and How to Use Wireshark to Analyze Network Performance which might be helpful.
Please also check Diagnosing problems with the JDBC driver.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.