Skip to main content
Question

Facing Read Timed Out issue when writing to ODS connection via JDBC connection

  • February 25, 2021
  • 2 replies
  • 47 views

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.

2 replies

rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • February 25, 2021

hi @vioarx​ 

Can you clarify how are you trying to connect to Azure SQL Server?

Are you using JDBC Reader or Microsoft Azure SQL Database Spatial (JDBC) reader?

Are you able to connect to Azure Server using FME? Please try it using FME Data Inspector.

 


  • Author
  • February 26, 2021
rahulsharma wrote:

hi @vioarx​ 

Can you clarify how are you trying to connect to Azure SQL Server?

Are you using JDBC Reader or Microsoft Azure SQL Database Spatial (JDBC) reader?

Are you able to connect to Azure Server using FME? Please try it using FME Data Inspector.

 

I am using JDBC Reader and Microsoft Azure SQL Database Spatial (JDBC) writer.

When using FME Data Inspector I can read all the values.

the error is when I am writing to the Azure SQL Database.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings