One Star

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
2 REPLIES
Moderator

Re: Teradata connection not working

Hi,
Can you successfully connect to your teradata DB through client without using talend tool?
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.
One Star

Re: Teradata connection not working

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