topic Re: Connection Timeout Problemmmmmmmm... in Talend Studio

Connection Timeout Problemmmmmmmm...

_AnonymousUser — Sat, 16 Nov 2024 14:33:27 GMT

Hi All,
I am trying to migrate the data from flat file to DB2 using Talend.
Following Components are used:
Tmap
TDb2output.
The problem i have is connection timeout on db2 server side.
There is no error.
Error message by Talend:
*********************************************************************************
Exception in component tDB2Input_1
Exception in component tDB2Input_1
Exception in component tDB2Input_1
com.ibm.db2.jcc.a.DisconnectException: java.net.ConnectException : Error opening socket to server BLREQR2008/129.1.32.16 on port 50000 with message : Connection timed out: connect DB2ConnectionCorrelator: null
at com.ibm.db2.jcc.b.fc.a(fc.java:371)
at com.ibm.db2.jcc.b.fc.<init>(fc.java:66)
at com.ibm.db2.jcc.b.a.v(a.java:254)
at com.ibm.db2.jcc.b.b.a(b.java:1792)
at com.ibm.db2.jcc.a.p.<init>(p.java:936)
at com.ibm.db2.jcc.b.b.<init>(b.java:324)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.tDB2Input_1Process(SAVTODB2_GLD0DATA.java:10877)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.tFileInputPositional_1Process(SAVTODB2_GLD0DATA.java:1542)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.tJava_1Process(SAVTODB2_GLD0DATA.java:10559)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.main(SAVTODB2_GLD0DATA.java:12837)
********************************************************************************************
Question : how can i increase the connection timeout on Talend site or i do have to do on db2 server side.
this problem is very frequent.
plzzzzzz help me out....

Re: Connection Timeout Problemmmmmmmm...

_AnonymousUser — Mon, 12 Nov 2007 06:55:03 GMT

yes.. i am also facing the same problem..
if the db2 server is on the local machine, then we dont get this error..
if the server is on the different machine, then we get this error very frequently..
is this the problem with TALEND or with DB2?
my second question is why do we need seperated connection for each DB2Out ??cant we have one connection for all output tables?

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Mon, 12 Nov 2007 08:41:40 GMT

Hi
about the first question, we have tested DB2 components to connect to different machine and they run fine, so I think it's depend on your machine or connection timeout. you can try to change your timeout on DB2 server.

why do we need seperated connection for each DB2Out ??cant we have one connection for all output tables?

we have created the connection component for the main databases, such as: tMySQLConnection, about this kind component for DB2, please report a new features in our bugtracker.
Thanks for your support !
Best regards

shong

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Fri, 23 Jul 2010 06:01:18 GMT

Hi,
Can anyone tell me the steps for importing data from csv file to our database in talend profiler.
thnaks
leena

Re: Connection Timeout Problemmmmmmmm...

_AnonymousUser — Wed, 01 Sep 2010 02:11:13 GMT

I am facing same exception though i am using tMySqlConnection component .I am trying to connect to remote server and session is getting removed

Re: Connection Timeout Problemmmmmmmm...

_AnonymousUser — Wed, 01 Sep 2010 02:12:56 GMT

Please help me with the solution to the session time out problem uasing Talend

Re: Connection Timeout Problemmmmmmmm...

janhess — Wed, 01 Sep 2010 09:08:50 GMT

I found this info. Don't know if it helps at all.
http://publib.boulder.ibm.com/infocenter/tamit721/v7r2m1/index.jsp?topic=/com.ibm.license.mgmt.probdet.doc/r_probs_databaseinstall.html
The connection with the database cannot be established despite the fact that the values specified for the tlmsrv user, host name and port number are correct. The <temp_dir>/tad4d721/Server.log contains the following error message: A SQLException caught: java.net.ConnectException : Error opening socket to server <db2_host> on port <db2_port> with message : Connection timed out DB2ConnectionCorrelator: null.
Try to connect to the database using the DB2 client to find out more about the problem.

Also found info suggesting you need to use a DB2 type 4 driver.

Re: Connection Timeout Problemmmmmmmm...

_AnonymousUser — Wed, 01 Sep 2010 19:05:36 GMT

How about the issue i am facing using the tMySqlConnection.
I observed that after a period of time database connection session is lossed.
Please suggest

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Wed, 17 Apr 2013 23:09:22 GMT

Please help I'm getting this error message..
Exception in component tMysqlInput_11
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 1,148 milliseconds ago. The last packet sent successfully to the server was 421,259 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1929)
at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:417)

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Thu, 18 Apr 2013 03:46:28 GMT

Hi rockysree
Search forum topics with key word "Communications link failure", you will find many similar topics, that provide the possible causes and solutions.
Shong

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Thu, 18 Apr 2013 17:47:48 GMT

I can confirm, the tDB2 components works well even if the DB2 server is not the on the same machine. The mentioned error is a misconfiguration in the server or in the connection properties.

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Fri, 19 Apr 2013 00:06:24 GMT

Thank you guys, I will check on the suggestions, Thanks again

Re: Connection Timeout Problemmmmmmmm...

_AnonymousUser — Fri, 12 Sep 2014 18:19:20 GMT

Bonojur
Quand j'exécute, mon job talend, je reçois l'erreur suivante :
Exception in component tDB2Input_3
com.ibm.db2.jcc.a.DisconnectException: java.net.BindException : Error opening socket to server VMERMAC/56.45.118.86 on port 50000 with message : Address already in use: connect DB2ConnectionCorrelator: null
at com.ibm.db2.jcc.b.fc.a(fc.java:371)
at com.ibm.db2.jcc.b.fc.<init>(fc.java:66)
at com.ibm.db2.jcc.b.a.v(a.java:254)
at com.ibm.db2.jcc.b.b.a(b.java:1792)
at com.ibm.db2.jcc.a.p.<init>(p.java:936)
at com.ibm.db2.jcc.b.b.<init>(b.java:324)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.tDB2Input_3Process(Alimentation_lot1_tables_base1_SI.java:13649)
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.tDB2Input_1Process(Alimentation_lot1_tables_base1_SI.java:8275)
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.runJobInTOS(Alimentation_lot1_tables_base1_SI.java:14019)
disconnected
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.runJob(Alimentation_lot1_tables_base1_SI.java:13866)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_1Process(JOB_DWH_MASTER.java:963)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_19Process(JOB_DWH_MASTER.java:842)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.runJobInTOS(JOB_DWH_MASTER.java:4521)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.main(JOB_DWH_MASTER.java:4362)
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_1Process(JOB_DWH_MASTER.java:982)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_19Process(JOB_DWH_MASTER.java:842)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.runJobInTOS(JOB_DWH_MASTER.java:4521)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.main(JOB_DWH_MASTER.java:4362)
Job JOB_DWH_MASTER terminé à 12:31 12/09/2014.
est ce que quelqu'un peut m'aider ?
Merci

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Mon, 15 Sep 2014 08:42:40 GMT

Hi ilhamiss,
This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!

Exception in component tDB2Input_3
com.ibm.db2.jcc.a.DisconnectException: java.net.BindException : Error opening socket to server VMERMAC/56.45.118.86 on port 50000 with message : Address already in use: connect DB2ConnectionCorrelator: null

For your issue, is port 50000 (the default DB2 port) the right one? Can you connect to DB2 server without using Talend Tool? Please verify that the credentials you've used in the component are right.
Best regards
Sabrina

Re: Connection Timeout Problemmmmmmmm...

Anonymous — Mon, 15 Sep 2014 11:02:48 GMT

I work every week since 3 years with Talend and DB2 and it works well. This problem is definitely not caused by Talend because at this time the JDBC driver tries to establish the connection and this functionality is not changed or manipulated by Talend Studio.
I guess you are unable to establish a connection with any other JDBC based database tool like SQLDeveloper or SQuirrel or DBVisualizer etc.
Please post us the connection properties.