teradata connection failed

[Jayme_Martin]

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 

[Anonymous]

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

[Jayme_Martin]

Hello Sabrina!

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

    Thanks Sabrina

[Anonymous]

Hello,

Did you install required jar files in your studio?

Best regards

Sabrina

[Jayme_Martin]

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

[Anonymous]

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

[naveen238299]

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

[naveen238299]

I am attaching the error screenshot-