Teradata JDBC Connection Failure

Connectivity
N/A

Teradata JDBC Connection Failure

Hi

I installed Teradata studio express 15 on windows 7-32 bit.

I am facing issue while setting Teradata connection.

Exception-

java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.09] [Error 1000] [SQLState 08S01] Login failure for Packet receive Thu May 12 00:06:49 IST 2016 socket orig=192.168.2.2 local=0.0.0.0/0.0.0.0:18156 remote=/192.168.2.2:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=1 connecttotaltime=2 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=18831cc sess=0 java.io.IOException: Incomplete LAN message header: read 24 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:712)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:102)   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:233)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:159)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:122)   at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)   at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)   at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)   at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)   at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)   at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)   at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)   at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)  

    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.read(TDNetworkIOIF.java:890)

    at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)

    at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:102)

    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:233)

    at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:159)

    at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277)

    at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:122)

    at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

    at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)

    at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)

    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

    at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

    at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: java.io.IOException: Incomplete LAN message header: read 24 bytes

    at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:712)

    ... 20 more

3 REPLIES
Teradata Employee

Re: Teradata JDBC Connection Failure

You specified 192.168.2.2 as your Teradata Database hostname. Is that correct? Is there a Teradata Database running on a machine with that IP address.

I'm asking because 192.168.x.x is an IP address range for private networks.

Re: Teradata JDBC Connection Failure

Hi Tomnolan,

I'm also facing the same issue when I tried to create a new connection profile Teradata studio express 15. 

How can I check database is running in my system? and I'm using standalone computer.

Thanks,

Rajeshkumar.

Teradata Employee

Re: Teradata JDBC Connection Failure

Teradata Studio Express does not include the Teradata Database.

There are several free versions of the Teradata Database available for download. You must download them separately from Teradata Studio.

Go to the Downloads page of Developer Exchange, click on the version of the Teradata Database that you want to use, then follow the instructions.