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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
ARavi1653219680
Contributor
Contributor

Talend - IBM DB2 connection failure

Hi Team

I am using Talend open studio 8.1, I had created Metadata DB2 connection and while testing connection I am getting the error shown below.

Can some help me here?

Connection failure. You must change the Database Settings.

java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.14.111] Exception java.net.SocketTimeoutException: Error opening socket to server tsoc/147.179.190.117 on port 446 with message: Connect timed out. ERRORCODE=-4499, SQLSTATE=08001

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:1)

at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)

at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.14.111] Exception java.net.SocketTimeoutException: Error opening socket to server tsoc/147.179.190.117 on port 446 with message: Connect timed out. ERRORCODE=-4499, SQLSTATE=08001

at com.ibm.db2.jcc.am.ed.a(ed.java:320)

at com.ibm.db2.jcc.am.ed.a(ed.java:338)

at com.ibm.db2.jcc.t4.vb.a(vb.java:434)

at com.ibm.db2.jcc.t4.vb.<init>(vb.java:93)

at com.ibm.db2.jcc.t4.a.b(a.java:354)

at com.ibm.db2.jcc.t4.b.newAgent_(b.java:2030)

at com.ibm.db2.jcc.am.Connection.initConnection(Connection.java:731)

at com.ibm.db2.jcc.am.Connection.<init>(Connection.java:680)

at com.ibm.db2.jcc.t4.b.<init>(b.java:334)

at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:232)

at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:198)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:475)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:116)

at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)

... 9 more

Caused by: java.net.SocketTimeoutException: Connect timed out

at java.net.SocksSocketImpl.readSocksReply(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at com.ibm.db2.jcc.t4.v.run(v.java:49)

at java.security.AccessController.doPrivileged(Native Method)

at com.ibm.db2.jcc.t4.vb.a(vb.java:420)

... 21 more

Labels (2)
2 Replies
Anonymous
Not applicable

Hi Ravi,

 

Does the same credentials work outside talend from the same studio machine? Can you please try connecting to the same DB from tDBconnection component?

ARavi1653219680
Contributor
Contributor
Author

Thanks. It's firewall issue, I solved it.