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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Teradata connection not working

Hi,
While i am trying to test teradata connection after filling in all details. Its showing some error.
Additional JDBC parameters text box is appearing in red color empty box. Do we need to provide any details in it.
Use SQL Mode: I have tried with both 'Yes' and 'No'
Version using:TOS_DI-20161026_1219-V6.3.0
Error:
Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: com.teradata.jdbc.jdbc_4.util.JDBCException: Login failure for Connection to prdm.health.ge.com Wed Jan 18 13:48:31 IST 2017 socket orig=prdm.health.ge.com cid=c42c19 sess=0 java.net.SocketException: Connection reset   at java.net.SocketInputStream.read(SocketInputStream.java:209)   at java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:124)   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:459)   at java.net.Socket.connect(Socket.java:589)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:330)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:87)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:582)   at com.teradata.jdbc.jdbc.GenericStateController.<init>(GenericStateController.java:41)   at com.teradata.jdbc.jdbc.GenericLogonController.<init>(GenericLogonController.java:40)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:200)   at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:99)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:54)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:218)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:151)   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)   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)   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$59.runWithCancel(DatabaseForm.java:3812)   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.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:745)  
      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:1092)
      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$59.runWithCancel(DatabaseForm.java:3812)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.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:745)
  Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: Login failure for Connection to prdm.health.ge.com Wed Jan 18 13:48:31 IST 2017 socket orig=prdm.health.ge.com cid=c42c19 sess=0 java.net.SocketException: Connection reset   at java.net.SocketInputStream.read(SocketInputStream.java:209)   at java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:124)   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:459)   at java.net.Socket.connect(Socket.java:589)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:330)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:87)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:582)   at com.teradata.jdbc.jdbc.GenericStateController.<init>(GenericStateController.java:41)   at com.teradata.jdbc.jdbc.GenericLogonController.<init>(GenericLogonController.java:40)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:200)   at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:99)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:54)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:218)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:151)   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)   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)   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$59.runWithCancel(DatabaseForm.java:3812)   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.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:745)  
      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:92)
      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:67)
      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:216)
      at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:56)
      at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:97)
      at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:582)
      at com.teradata.jdbc.jdbc.GenericStateController.<init>(GenericStateController.java:41)
      at com.teradata.jdbc.jdbc.GenericLogonController.<init>(GenericLogonController.java:40)
      at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:200)
      at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:99)
      at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:54)
      at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:218)
      at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:151)
      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.SocketException: Connection reset
      at java.net.SocketInputStream.read(SocketInputStream.java:209)
      at java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:124)
      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:459)
      at java.net.Socket.connect(Socket.java:589)
      at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:330)
      at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:87)
      ... 19 more
Regards,
Naveen Kumar
Labels (4)
2 Replies
Anonymous
Not applicable
Author

Hi,
Can you successfully connect to your teradata DB through client without using talend tool?
Best regards
Sabrina
Anonymous
Not applicable
Author

HI,
Yes, From Back end we are able to connect. I started facing this issue in 6.3 version only. Never faced this earlier. Not sure if any change has happened from configuration point of view.
Regards,
Naveen Kumar