teradata connection failed

Jayme_Martin — Thu, 11 Apr 2019 15:46:04 GMT

Hello,

I upgrade Talend to 7.1. and when i try to conect to Teradata DataBase make this error:

Connection failure. You must change the Database Settings.

java.lang.RuntimeException: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 1277] [SQLState 08S01] Login timeout for Connection to dwh.pro.veci.geci Thu Apr 11 16:22:36 CEST 2019 socket orig=dwh.pro.veci.geci cid=678a2 sess=0 java.net.SocketTimeoutException: connect timed out at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1218)

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

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

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

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

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

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.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(FutureTask.java:266)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 1277] [SQLState 08S01] Login timeout for Connection to dwh.pro.veci.geci Thu Apr 11 16:22:36 CEST 2019 socket orig=dwh.pro.veci.geci cid=678a2 sess=0 java.net.SocketTimeoutException: connect timed out at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1218)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207)

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:157)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:136)

at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:130)

at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)

at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208)

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)

at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:234)

at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:160)

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:195)

... 9 more

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

at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:589)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1218)

¿Some one have an a idea?

thaks

Re: teradata connection failed

Anonymous — Tue, 16 Apr 2019 10:41:21 GMT

Hello,

From exception stack trace, it seems that the Teradata JDBC Driver was unable to connect to the Teradata Database.

Are you able to ping the Teradata Database from the client? What's Teradata Database version are you trying to connect?

Best regards

Sabrina

Re: teradata connection failed

Jayme_Martin — Fri, 26 Apr 2019 09:40:43 GMT

Hello Sabrina!

Yes, i can ping with the Teradata Database, the Teradata versión is 16.20.

Thanks Sabrina

Re: teradata connection failed

Anonymous — Fri, 26 Apr 2019 09:52:42 GMT

Hello,

Did you install required jar files in your studio?

Best regards

Sabrina

Re: teradata connection failed

Jayme_Martin — Tue, 30 Apr 2019 10:04:20 GMT

Hi!!

Yes, all teradata JDBC is installed.

I see, is installed 2 versión of JDBC, 15.10 and 16.20.

Can be a problem?

best regards

Captura.PNG

Re: teradata connection failed

Anonymous — Tue, 30 Apr 2019 10:45:10 GMT

Hello @mhodent

Have you already checked your firewall which may be blocking the connection? If this is a multi-node Teradata Database, the firewall should be configured to permit connections to each Teradata Database node that is running a Gateway process.

Best regards

Sabrina

Re: teradata connection failed

naveen238299 — Tue, 23 Jun 2020 21:57:43 GMT

Unable to establish Teradata connection using Talend 7.2 Open studio version. However, my connection is working fine with Talend Big data Platform 7.1.1.

I am getting the below error message - Exception in thread "main" java.lang.exceptionInitializererror.

JDK6_SQL_connection

Re: teradata connection failed

naveen238299 — Tue, 23 Jun 2020 22:00:54 GMT

I am attaching the error screenshot-

topic Re: teradata connection failed in Data Quality

teradata connection failed

Re: teradata connection failed

Re: teradata connection failed

Re: teradata connection failed

Re: teradata connection failed

Re: teradata connection failed

Re: teradata connection failed

Re: teradata connection failed