I was trying to write data from a JDBC connection to an ODS via a JDBC connection. Some times i am facing the below issue
2021-02-25 20:34:57|1245.3| 0.0|INFORM|MS Azure SQL Database Spatial (JDBC) Writer: Committing feature 197000
com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2670)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1990)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6494)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7741)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7700)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.doInsertBulk(SQLServerBulkCopy.java:1615)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.access$200(SQLServerBulkCopy.java:58)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy$1InsertBulk.doExecute(SQLServerBulkCopy.java:709)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.sendBulkLoadBCP(SQLServerBulkCopy.java:739)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:1688)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:669)
at COM.safe.fme.jdbc.mssql.BulkCopierFeatureBundler.sendFeatures(BulkCopierFeatureBundler.java:154)
at COM.safe.fme.jdbc.JdbcWriter.commitTransaction(JdbcWriter.java:674)
at COM.safe.fme.jdbc.JdbcWriter.write(JdbcWriter.java:269)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:1009)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:997)
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
at sun.security.ssl.InputRecord.read(InputRecord.java:503)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:933)
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1983)
... 14 more
2021-02-25 20:35:33|1245.4| 0.1|ERROR |com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
2021-02-25 20:35:33|1245.4| 0.0|ERROR |com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
2021-02-25 20:35:33|1245.4| 0.0|ERROR |Azure_ODS_Production_Writer (WriterFactory): com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out
2021-02-25 20:35:37|1249.3| 3.9|INFORM|MS Azure SQL Database Spatial (JDBC) Writer: Committing feature 197000
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:233)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:1672)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:669)
at COM.safe.fme.jdbc.mssql.BulkCopierFeatureBundler.sendFeatures(BulkCopierFeatureBundler.java:154)
at COM.safe.fme.jdbc.JdbcWriter.commitTransaction(JdbcWriter.java:674)
at COM.safe.fme.jdbc.JdbcWriter.close(JdbcWriter.java:183)
2021-02-25 20:35:37|1249.3| 0.0|ERROR |com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
2021-02-25 20:35:37|1249.3| 0.0|ERROR |com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
with this log the workbench got stopped and failed.