Four Stars

Did anyone has tried for teradata metadata connection with Talend instead of general JDBC one i have been facing the issue please guide

Did anyone has tried for Teradata metadata connection with Talend instead of general JDBC one i have been facing the issue please guide

4 REPLIES
Moderator

Re: Did anyone has tried for teradata metadata connection with Talend instead of general JDBC one i have been facing the issue please guide

Hi,

What's the error you are experiencing? Could you please give us more information about your issue? Which will be helpful for us to understand your situation.

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.
Four Stars

Re: Did anyone has tried for teradata metadata connection with Talend instead of general JDBC one i have been facing the issue please guide

teradata is on citrix server and talend is on my local machine and when i try to create a talend database connection i get socket connection error
Four Stars

Re: Did anyone has tried for teradata metadata connection with Talend instead of general JDBC one i have been facing the issue please guide

also find the below error i got

 

Starting job Teradata_Connection at 15:31 10/10/2017.

 

[statistics] connecting to socket on port 3613

[statistics] connected

2017-10-10.15:32:00.362 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@39ba5a14 Connection to dwtcop1.han.telia.se Tue Oct 10 15:32:00 IST 2017 socket orig=dwtcop1.han.telia.se cid=7d68ef40 sess=0 java.net.SocketTimeoutException: connect timed out   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)   at java.net.PlainSocketImpl.connect(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1218) 

Exception in component tTeradataConnection_1 (Teradata_Connection)

java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 1277] [SQLState 08S01] Login timeout for Connection to dwtcop1.han.telia.se Tue Oct 10 15:32:00 IST 2017 socket orig=dwtcop1.han.telia.se cid=7d68ef40 sess=0 java.net.SocketTimeoutException: connect timed out   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)   at java.net.PlainSocketImpl.connect(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   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 java.sql.DriverManager.getConnection(Unknown Source)

      at java.sql.DriverManager.getConnection(Unknown Source)

      at local_project.teradata_connection_0_1.Teradata_Connection.tTeradataConnection_1Process(Teradata_Connection.java:409)

      at local_project.teradata_connection_0_1.Teradata_Connection.runJobInTOS(Teradata_Connection.java:936)

      at local_project.teradata_connection_0_1.Teradata_Connection.main(Teradata_Connection.java:785)

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

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

      at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

      at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

      at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

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

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

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

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

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

 

Four Stars

Re: Did anyone has tried for teradata metadata connection with Talend instead of general JDBC one i have been facing the issue please guide

teradata 14.1 version and talend 6.4.1 64bit