MSSQLROW & MSSQLOUTPUT | I/O Connection Reset Issue

_AnonymousUser — Fri, 10 Feb 2017 09:31:00 GMT

Hi Gurus,
We are using Talend 5.5.1.r118616 version of the TOS and using sql server 2012 as the DB. Many a times, we are getting the following errors while reading/writing to a DB table. These errors are very frequent, we consulted the DBA as well but every time, it comes out that there no network or DB server glitch.
Error 1
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1699)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2401)
at etl.j_e_smt_stt_rt_22_0.j_e_smt_stt_rt.tStatCatcher_1Process(j_e_sm_spt.java:27766)
at etl.j_e_art_stt_rt_22_0.j_e_st_stt_rt.runJobInTOS(j_e_smart_stdeqpt_rt.java:31539)
at etl.j_e_srt_stt_rt_22_0.j_e_st_stt_rt.runJob(j_e_sm.java:30368)
at etl.j_extt_rt_0_4.j_et_rt.tRunJob_2Process(j_extract.java:5177)
at etl.j_ext_rt_0_4.j_etract_rt.tJava_5Process(j_extract.java:4430)
at etl.j_extt_rt_0_4.j_ect_rt$3.run(j_extract_rt.java:16978)
Exception in component tRunJob_2

Error 2
Exception in component tMSSqlInput_2
java.sql.SQLException: I/O Error: Connection reset

Please throw some light on this as it is getting very difficult to load the DB.

Regards,
Ashish

Re: MSSQLROW & MSSQLOUTPUT | I/O Connection Reset Issue

Anonymous — Mon, 13 Feb 2017 03:24:36 GMT

Hi Ashish,
Have you tried to increase the timeout of your connection to see if it works? Does this issue repro on other build version(6.3..)?
Best regards
Sabrina

topic MSSQLROW & MSSQLOUTPUT | I/O Connection Reset Issue in Talend Studio

MSSQLROW & MSSQLOUTPUT | I/O Connection Reset Issue

Re: MSSQLROW & MSSQLOUTPUT | I/O Connection Reset Issue