java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.15] [Error 1277] [SQLState 08S01] Login timeout for Connection to ICW_Iberia Tue Aug 02 10:37:06 CEST 2016 socket orig=ICW_Iberia cid=46a9759f sess=0 java.net.SocketTimeoutException: connect timed out

rssing.com | 3 months ago
  1. 0

    Teradata Developer Exchange - Connectivity

    rssing.com | 3 months ago
    java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.15] [Error 1277] [SQLState 08S01] Login timeout for Connection to ICW_Iberia Tue Aug 02 10:37:06 CEST 2016 socket orig=ICW_Iberia cid=46a9759f sess=0 java.net.SocketTimeoutException: connect timed out
  2. 0

    Access External Data - A Table UDF | Teradata Developer Exchange

    teradata.com | 7 months ago
    java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive Mon Jan 25 10:13:51 MST 2016 socket orig=dev local=0.0.0.0/0.0.0.0:39620 remote=devcop3/10.22.76.12:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=2 connecttotaltime=2 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=ba75769 sess=1620968 java.io.IOException: Incomplete LAN message header: read 0 bytes
  3. 0

    Teradata login timeout | Teradata Developer Exchange

    teradata.com | 5 months ago
    java.sql.SQLException: Cannot create PoolableConnectionFactory ([Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1277] [SQLState 08S01] Login timeout for Packet receive Thu Feb 11 09:17:09 EST 2016 socket orig=10.15.9.10 local=/10.94.148.229:50569 remote=/10.15.9.10:1025 keepalive=false nodelay=false receive=65156 send=65156 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=41 connecttotaltime=109 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=1c01f855 sess=272801 java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStrea m.java:116) at java.net.SocketInputStream.read(SocketInputStream.java :170) at java.net.SocketInputStream.read(SocketInputStream.java :141) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetwo rkIOIF.java:697) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream( TDPacketStream.java:773) at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:486) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:205) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6 _SQL_Connection.java:35) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct SQLConnection(JDK6ConnectionFactory.java:25) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:179) at com.teradata.jdbc.jdbc.ManagerConnectionBase.<init>(Ma nagerConnectionBase.java:47) at com.teradata.jdbc.jdbc.fastexport.FastExportManagerCon nection.<init>(FastExportManagerConnection.java:61) at com.teradata.jdbc.jdk6.JDK6_FastExportManager_Connecti on.<init>(JDK6_FastExportManager_Connection.java:28) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct FastExportManagerConnection(JDK6ConnectionFactory.java :43) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:210) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:169) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java :232) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java: 158) at org.apache.commons.dbcp2.DriverConnectionFactory.creat eConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.mak eObject(PoolableConnectionFactory.java:205) at org.apache.commons.dbcp2.BasicDataSource.validateConne ctionFactory(BasicDataSource.java:2162) at org.apache.commons.dbcp2.BasicDataSource.createPoolabl eConnectionFactory(BasicDataSource.java:2148) at org.apache.commons.dbcp2.BasicDataSource.createDataSou rce(BasicDataSource.java:1903) at org.apache.commons.dbcp2.BasicDataSource.getConnection (BasicDataSource.java:1413) at services.connector.JDBCConnectionPool$class.getConnect ion(JDBCConnectionPool.scala:22) at services.connector.TeradataConnectionPool$.getConnecti on(TeradataConnectionPool.scala:12) at services.connector.TeradataPollingDBConnector$.<init>( TeradataPollingDBConnector.scala:21) at services.connector.TeradataPollingDBConnector$.<clinit >(TeradataPollingDBConnector.scala) at services.connector.AkkaPollingFactory$.getPollingConne ctor(AkkaPollingFactory.scala:39) at services.connector.AkkaPollingUtility$.getLargestTimeB yTablename(AkkaPollingUtility.scala:145) at services.connector.AkkaPollingUtility$.getSqlParamList (AkkaPollingUtility.scala:52) at services.akka.SourceTablePoller$$anonfun$receive$1.app lyOrElse(SourceTablePoller.scala:32) at akka.actor.Actor$class.aroundReceive(Actor.scala:467) at services.akka.SourceTablePoller.aroundReceive(SourceTa blePoller.scala:16) at akka.actor.ActorCell.receiveMessage(ActorCell.scala: 516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoi nTask.exec(AbstractDispatcher.scala:397) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoin Task.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTa sk(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJ oinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(For kJoinWorkerThread.java:107) ) at org.apache.commons.dbcp2.BasicDataSource.createPoolabl eConnectionFactory(BasicDataSource.java:2152) at org.apache.commons.dbcp2.BasicDataSource.createDataSou rce(BasicDataSource.java:1903) at org.apache.commons.dbcp2.BasicDataSource.getConnection (BasicDataSource.java:1413) at services.connector.JDBCConnectionPool$class.getConnect ion(JDBCConnectionPool.scala:22) at services.connector.TeradataConnectionPool$.getConnecti on(TeradataConnectionPool.scala:12) at services.connector.TeradataPollingDBConnector$.<init>( TeradataPollingDBConnector.scala:21) at services.connector.TeradataPollingDBConnector$.<clinit >(TeradataPollingDBConnector.scala) at services.connector.AkkaPollingFactory$.getPollingConne ctor(AkkaPollingFactory.scala:39) at services.connector.AkkaPollingUtility$.getLargestTimeB yTablename(AkkaPollingUtility.scala:145) at services.connector.AkkaPollingUtility$.getSqlParamList (AkkaPollingUtility.scala:52) at services.akka.SourceTablePoller$$anonfun$receive$1.app lyOrElse(SourceTablePoller.scala:32)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    executeQuery not returning result for Hive

    Stack Overflow | 2 years ago | Chirag Bansal
    java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1103] [SQLState HY000] Cannot add an empty batch of rows to a database table
  6. 0

    Teradata createClob: function not supported in this version. Is this a bug or a feature?

    Stack Overflow | 1 month ago | john
    java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 165] [SQLState HY000] createClob: function not supported in this version

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      [Teradata JDBC Driver] [TeraJDBC 15.10.00.15] [Error 1277] [SQLState 08S01] Login timeout for Connection to ICW_Iberia Tue Aug 02 10:37:06 CEST 2016 socket orig=ICW_Iberia cid=46a9759f sess=0 java.net.SocketTimeoutException: connect timed out

      at java.net.PlainSocketImpl.socketConnect()
    2. Java RT
      Socket.connect
      1. java.net.PlainSocketImpl.socketConnect(Native Method)
      2. java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
      3. java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
      4. java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
      5. java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
      6. java.net.Socket.connect(Socket.java:589)
      6 frames
    3. com.teradata.jdbc
      TDNetworkIOIF$ConnectThread.run
      1. com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1224)
      1 frame