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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-10-05 12:59 AM

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

Labels (1)
Labels
283 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2017-10-12 01:23 AM
Author

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

283 Views
0 Likes
Anonymous
Not applicable
‎2017-10-12 02:23 AM
Author

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
283 Views
0 Likes
Anonymous
Not applicable
‎2017-10-12 02:26 AM
Author

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)

 

283 Views
0 Likes
Anonymous
Not applicable
‎2017-10-12 02:27 AM
Author

teradata 14.1 version and talend 6.4.1 64bit
283 Views
0 Likes