Teradata JDBC on Redhat Linux 7 can't connect to the Server.

Connectivity
Highlighted
Fan

Teradata JDBC on Redhat Linux 7 can't connect to the Server.

Hi, all
 
Did anyone experience this very weired symptom:
 
Client A: Redhat Linux 7 Firewall Disabled, can't connect to Teradata Server with the following error message. This client can connect to other Database using their JDBC driver properly.
 
Client B: A MacOS with same Teradata JDBC driver in the Same network segment,  can connect normally.
 
[Teradata JDBC Driver] [TeraJDBC 16.20.00.06] [Error 1000] [SQLState 08S01] Login failure for Packet receive Wed May 23 11:32:12 PDT 2018 
socket orig=alves.corp.xxxx.com local=0.0.0.0/0.0.0.0:50454 remote=alvescop52.corp.xxxx.com/17.140.165.52:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=19 connecttotaltime=19 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=34355e3e sess=0 
java.net.SocketException: Connection reset  at java.net.SocketInputStream.read(SocketInputStream.java:210)  at java.net.SocketInputStream.read(SocketInputStream.java:141)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:747)  at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:800)  at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:104)  at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:211)  at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:36)  at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:181)  at com.teradata.jdbc.jdbc.Connect
3 REPLIES
Teradata Employee

Re: Teradata JDBC on Redhat Linux 7 can't connect to the Server.

Appears to have received TCP RST instead of logon handshake.

Did the hostname/COP resolve to a correct IP for one of the database nodes?

Fan

Re: Teradata JDBC on Redhat Linux 7 can't connect to the Server.

I think so.

From Client A, I can ping both alves.corp.xxxx.com and alvescop51.corp.xxxx.com.

Even if I use IP address directly in the JDBC, it has the same error code.

 

Teradata Employee

Re: Teradata JDBC on Redhat Linux 7 can't connect to the Server.

Yes, we have seen this kind of exception before. It can be due to a networking problem. If you are a Teradata customer, then please open an incident with Teradata Customer Support.