Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

MSSQLROW & MSSQLOUTPUT | I/O Connection Reset Issue

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

Labels (2)
1 Reply
Anonymous
Not applicable

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