One Star

I/O Error: DB server closed connection

Hello,
I am getting below error message while using tMSSqlConnection.
Starting job EndToEndReconciliation at 15:48 08/09/2015.
connecting to socket on port 3614
connected
Exception in component tMSSqlConnection_3
java.sql.SQLException: I/O Error: DB server closed connection.
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2311)
 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:610)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at oi_xlh_ops.endtoendreconciliation_0_1.EndToEndReconciliation.tMSSqlConnection_3Process(EndToEndReconciliation.java:316)
 at oi_xlh_ops.endtoendreconciliation_0_1.EndToEndReconciliation.runJobInTOS(EndToEndReconciliation.java:585)
 at oi_xlh_ops.endtoendreconciliation_0_1.EndToEndReconciliation.main(EndToEndReconciliation.java:442)
Caused by: java.io.IOException: DB server closed connection.
 at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:848)
disconnected
 at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:727)
 at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
 at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2206)
 ... 9 more
Job EndToEndReconciliation ended at 15:48 08/09/2015.


Thanks in advance for your help.
Sam
9 REPLIES
Moderator

Re: I/O Error: DB server closed connection

Hi sam,
Do you enable force encryption(ssl required) on SQL server? Can you connect to SQL server from management studio successfully without using Talend Tool?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: I/O Error: DB server closed connection

Hello Sabrina,
Thank you for your reply.
Yes I am able to connect to SQL Server from management studio without using Talend tool.
I have 4 different servers and I am able to use 2 in Talend and for other 2 I am getting this error though I have all the required permission for all 4 servers.
Thanks,
Sam
Moderator

Re: I/O Error: DB server closed connection

Hi sam,
What does your job design look like? Are you using "Use or register a shared DB Connection" in it? Have you tried to set up DB connection in metadata to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: I/O Error: DB server closed connection

Hello Sabrina,

I am using just tMSSqlconnection. I am not using "Use or register a shared DB Connection".

I have tried to set up DB connection in metadata and its working for the server which was already working with tMSSqlconnection but I am getting error for the server which was not working with tMSSqlconnection.

Please check the images in attachments.

Thanks,
Sam                                                  

                                                                           
Moderator

Re: I/O Error: DB server closed connection

Hi,
I have tried to set up DB connection in metadata and its working for the server which was already working with tMSSqlconnection but I am getting error for the server which was not working with tMSSqlconnection.

Do you mean server A is Ok but not server B? Can you connect your server B successing without using Talend Tool?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: I/O Error: DB server closed connection

Hi,
Yes I am able to connect to Server B without using Talend Tool.

Sam
One Star

Re: I/O Error: DB server closed connection

Hi Talend Team,
Can you please update on this ,i also faced same issue.
One Star

Re: I/O Error: DB server closed connection

Hi Talend,
I am also facing same issue.
Can you help us to get what is going wrong?
Thanks,
Revathy
Moderator

Re: I/O Error: DB server closed connection

Hi Revathy,
What's your sql server version? On which talend build version you got this issue? What does your job look like?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.