All Forums Connectivity
vasu6 12 posts Joined 10/12
17 Oct 2013
Unable to create a connection using the jdbc:teradata://10.65.140.250/DATABASE=rts_dev

HI Team,
Here is the log file for connectivity through JDBC application from Application server to TD server on linux.
16-Oct-2013 09:57:01IST Unable to create a connection using the jdbc:teradata://10.65.140.050/ DATABASE=rts_dev,TMODE=ANSI,CHARSET=UTF16 URL with dbc username because of the following error: [Teradata JDBC Driver] [TeraJDBC 1
16-Oct-2013 09:57:01IST 4.00.00.00] [Error 1000] [SQLState 08S01] Login failure for Packet receive Wed Oct 16 09:57:01 IST 2013 socket orig=10.65.142.204 local=0.0.0.0/0.0.0.0:33409 remote=/10.65.142.204:1025 keepalive=unava
16-Oct-2013 09:57:01IST ilable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=6 connecttotaltime=8 connectattempts=1 con
16-Oct-2013 09:57:01IST nectfailures=0 failurecache={} cid=10fd7411 sess=20662 java.io.IOException: Incomplete LAN message header: read 0 bytes at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetwo rkIOIF.java:659) at c
16-Oct-2013 09:57:01IST om.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(T DPacketStream.java:818) at com.teradata.jdbc.jdbc.GenericEncryptContextState.acti on(GenericEncryptContextState.java:119) at com.teradata.jdbc.jd
16-Oct-2013 09:57:01IST bc.GenericLogonController.run(GenericLogonController.j ava:120) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:212) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6 _SQL_Connecti
16-Oct-2013 09:57:01IST on.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct Connection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:130
16-Oct-2013 09:57:01IST ) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java :220) at com.teradata.jdbc.TeraDriver.connect(Ter
16-Oct-2013 09:57:01IST aDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.jav a:579) at java.sql.DriverManager.getConnection(DriverManager.jav a:221) at com.applimation.jdbc.JdbcTemplateFactory$AMDataS
16-Oct-2013 09:57:01IST ource.createConnection(JdbcTemplateFactory.java:620) at com.applimation.jdbc.JdbcTemplateFactory$AMDataSource. getConnection(JdbcTemplateFactory.java:611) at com.applimation.jdbc.JdbcTemplateFactory.
16-Oct-2013 09:57:01IST createJdbcTemplate(JdbcTemplateFactory.java:421) at com.applimation.jdbc.JdbcTemplateFactory.createJdbcTem plate(JdbcTemplateFactory.java:487) at com.applimation.jdbc.JdbcTemplateFactory.getJdbcTempl
16-Oct-2013 09:57:01IST ateForStaging(JdbcTemplateFactory.java:515) at com.applimation.archive.dao.impl.AbstractArchiveEngine DAOImpl.getJdbcTemplateForStaging(AbstractArchiveEngin eDAOImpl.java:244) at com.applimation.archi
16-Oct-2013 09:57:01IST ve.dao.impl.InsertIntoDestinationTableDAOImpl.copyTabl eToDestination(InsertIntoDestinationTableDAOImpl.java: 167) at com.applimation.archive.services.thread.CopyToDestinat ionThread.run(CopyToDestinati
16-Oct-2013 09:57:01IST onThread.java:130) at com.applimation.services.thread.AMThreadQueueManager$A MThreadQueueElement.run(AMThreadQueueManager.java:503) at java.lang.Thread.run(Thread.java:722)
16-Oct-2013 09:57:01IST com.applimation.jdbc.JdbcTemplateFactory.createJdbcTem plate(JdbcTemplateFactory.java:446)
16-Oct-2013 09:57:01IST com.applimation.jdbc.JdbcTemplateFactory.createJdbcTem plate(JdbcTemplateFactory.java:487)
16-Oct-2013 09:57:01IST com.applimation.jdbc.JdbcTemplateFactory.getJdbcTempla teForStaging(JdbcTemplateFactory.java:515)
16-Oct-2013 09:57:01IST com.applimation.archive.dao.impl.AbstractArchiveEngine DAOImpl.getJdbcTemplateForStaging(AbstractArchiveEngin eDAOImpl.java:244)
16-Oct-2013 09:57:01IST com.applimation.archive.dao.impl.InsertIntoDestination TableDAOImpl.copyTableToDestination(InsertIntoDestinat ionTableDAOImpl.java:167)
16-Oct-2013 09:57:01IST com.applimation.archive.services.thread.CopyToDestinat ionThread.run(CopyToDestinationThread.java:130)
16-Oct-2013 09:57:01IST com.applimation.services.thread.AMThreadQueueManager$A MThreadQueueElement.run(AMThreadQueueManager.java:503)
16-Oct-2013 09:57:01IST java.lang.Thread.run(Thread.java:722)
 
Can you pelase help me on this ?
My id : vvdrmca@gmail.com
THanks in advance

Thanks, Vasudeva Rao
tomnolan 594 posts Joined 01/08
17 Oct 2013

Is your Java program running on a Linux machine? If so, then you may have encountered the "Slow Logon on Linux" problem. The problem, and workarounds, are documented in the Teradata JDBC Driver User Guide located here on Developer Exchange:
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html#CHDDACIH

You must sign in to leave a comment.