My Talend 6.2.1 job is pulling out data from one AZURE SQL Database and inserting it into another.
Since 29th July 2019, this job is throwing error CONNECTION RESET/CONNECTION CLOSED.
We analyzed that the issue is with connectivity with AZURE SQL Database. The connection is closed while the job is trying to pull data from a database.
Additional parameters we used are: encrypt=true;hostNameInCertificate=*.database.windows.net
Please let me know which additional parameters to be used to avoid this closed connection.
These workflows are in place since 2017. They are created in a fashion just like you specified in your reply.
Each job of this workflow starts with connection open -> transformation and load -> connection commit/close.
No modification has been done on this workflow and these all worked fine till 26th July.
But since 29th July 2019, when the workflow starts, it gives the following error:
Message : <module> : Job Failed : Exception in component tMSSqlConnection_1 java.sql.SQLException: Network error IOException: Connection reset at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at importfromprod.set_globalvariables_0_1.Set_globalVariables.tMSSqlConnection_1Process(Set_globalVariables.java:3535) at importfromprod.set_globalvariables_0_1.Set_globalVariables.runJobInTOS(Set_globalVariables.java:4926) at importfromprod.set_globalvariables_0_1.Set_globalVariables.runJob(Set_globalVariables.java:4781) at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.tRunJob_1Process(Prod_to_Rater_Wrapper.java:479) at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.runJobInTOS(Prod_to_Rater_Wrapper.java:750) at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.main(Prod_to_Rater_Wrapper.java:598) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:210) at java.net.SocketInputStream.read(SocketInputStream.java:141) at net.sourceforge.jtds.ssl.TdsTlsInputStream.readFully(TdsTlsInputStream.java:131) at net.sourceforge.jtds.ssl.TdsTlsInputStream.primeBuffer(TdsTlsInputStream.java:100) at net.sourceforge.jtds.ssl.TdsTlsInputStream.read(TdsTlsInputStream.java:78) 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:983) at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385) at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413) at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397) at net.sourceforge.jtds.ssl.SocketFactories$TdsTlsSocketFactory.createSocket(SocketFactories.java:101) at net.sourceforge.jtds.jdbc.SharedSocket.enableEncryption(SharedSocket.java:330) at net.sourceforge.jtds.jdbc.TdsCore.negotiateSSL(TdsCore.java:577) at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:365) ... 9 more Exception in component tRunJob_1 java.lang.RuntimeException: Child job running failed at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.tRunJob_1Process(Prod_to_Rater_Wrapper.java:501) at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.runJobInTOS(Prod_to_Rater_Wrapper.java:750) at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.main(Prod_to_Rater_Wrapper.java:598)
Please help me as these workflows are crucial and I am still struggling to find out the root cause of this error and finding its solution.
