Talend Open Studio giving me I/O Error: Connection reset by peer

[Anonymous]

Hi
I just got "I/O Error: Connection reset by peer: socket write error" when running an overnight job. I researched the problem on the internet and it seems its probably caused by many concurrent users on MS SQL Server confusing Java that socked was closed. Did anything similar happened to anyone in the community?
OS: Win7; DB: Microsoft SQL Server 2008.
Error message:
connecting to socket on port 4030
connected
I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_2
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:448)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.initialize(JtdsStatement.java:586)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:851)
at undq.test_fuzzy_trigram_without_joins_0_1.TEST_fuzzy_trigram_without_joins.tMSSqlInput_3Process(TEST_fuzzy_trigram_without_joins.java:3741)
at undq.test_fuzzy_trigram_without_joins_0_1.TEST_fuzzy_trigram_without_joins.runJobInTOS(TEST_fuzzy_trigram_without_joins.java:5298)
at undq.test_fuzzy_trigram_without_joins_0_1.TEST_fuzzy_trigram_without_joins.main(TEST_fuzzy_trigram_without_joins.java:5172)
disconnected
Job TEST_fuzzy_trigram_without_joins ended at 20:50 30/06/2010.

[Anonymous]

More on this error: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68088
This is the great forum discussion regarding this error - not Talend related of course, but very informative.

[Anonymous]

Same error on Windows 10 / Talend DI OS 6.1.1 while connecting to Azure SQL database v12
I/O Error: Connection reset by peer: socket write error
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1030)
at adwh.gen_0_1.gen.tRowGenerator_1Process(gen.java:837)
at adwh.gen_0_1.gen.runJobInTOS(gen.java:1221)
at adwh.gen_0_1.gen.main(gen.java:1078)

[Anonymous]

Did you tried it with other JDBC based tools? Perhaps the JDBC driver is out-dated.

[Anonymous]

@kotyara
Did you have a resolution to this problem?  I can only write to Azure if my batch size is 10 (down from default of 10000).  This makes the job take too long.

[Anonymous]

Hi 
I am facing this error continuously while getting data in SQL developer from Salesforce. Did any one facing the same error.Please let me know how to solve this error.
Starting job Replication at 10:24 05/10/2016.
connecting to socket on port 3423
connected
IO Error: Connection reset by peer: socket write error
Exception in component tOracleOutput_13
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4296)
at oracle.jdbc.driver.OracleStatement.getUpdateCount(OracleStatement.java:3407)
at oracle.jdbc.driver.OracleStatementWrapper.getUpdateCount(OracleStatementWrapper.java:204)
at gittest3___java.replication_0_1.Replication.tSalesforceInput_13Process(Replication.java:8661)
at gittest3___java.replication_0_1.Replication.runJobInTOS(Replication.java:9090)
at gittest3___java.replication_0_1.Replication.main(Replication.java:8947)
disconnected
Job Replication ended at 10:42 05/10/2016.

[Anonymous]

@Neha please increase the timeout of your connection

[Anonymous]

Neha,
Connection timeout our SQL execution timeout? How do you increase the timeout?
We are getting this error every day.

[Anonymous]

This error cannot be solved by increasing the timeout. The root cause is simply a misconfiguration of the host and port of the database.

[_AnonymousUser]

@ jlolling 

Any help on this ?
I am struggling with this for quite a while now.