Teradata connection not working

Anonymous — Wed, 18 Jan 2017 08:20:55 GMT

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

Re: Teradata connection not working

Anonymous — Thu, 19 Jan 2017 06:36:07 GMT

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

Re: Teradata connection not working

Anonymous — Tue, 31 Jan 2017 09:18:35 GMT

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

topic Teradata connection not working in Talend Studio

Teradata connection not working

Re: Teradata connection not working

Re: Teradata connection not working