17.00 - Troubleshoot JDBC with the Stack - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

prodname
Geospatial Utilities
vrm_release
17.00
created_date
June 2020
category
User Guide
featnum
B035-2519-220K

Troubleshoot JDBC with the stack, which indicates RDBMS crash or down:

D:\anuguraju\anuguraju\GeoSpatial\TestEnv>java -Xms256m -Xmx1024m
-classpath .;tdgssconfig.jar;terajdbc4.jar;tdgeospatial.jar; com.teradata.geo.TDGeoExport
  -l hyvm111/ab,ab -s ab -t customers -f "ESRI Shapefile" point
  -o D:\anuguraju\anuguraju\GeoSpatial\TestEnv\geodata -n customers
Coordinate System defaulting to NAD83.
WARNING: There is data in the directory 
D:\ANUGURAJU\ANUGURAJU\GEOSPATIAL\TESTEN
V\GEODATA which was specified.
If you continue, and there is pre-existing data for layer CUSTOMERS, all 
data for that layer will be OVERWRITTEN.
Would you like to continue? [y,n] y
Logon        = hyvm111/ab,****
DatabaseName = AB
Table Name   = CUSTOMERS
Export to    = D:\ANUGURAJU\ANUGURAJU\GEOSPATIAL\TESTENV\GEODATA\CUSTOMERS
File Format  = ESRI Shapefile
Shape Type   = POINT
Only 1 Type  = FALSE
-------------------------------------------
connecting to hyvm111 ...2014-01-07.14:26:10.963 TERAJDBC4 ERROR [main] 
com.teradata.jdbc.jdk6.JDK6_SQL_Connection@1dff3a2 Connection to hyvm111 
Tue Jan 07 14:2 6:10 IST 2014 socket orig=hyvm111 cid=8f4fb3 sess=0 
java.net.SocketTimeoutException: connect timed out  at 
java.net.PlainSocketImpl.socketConnect(Native Method)  at 
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)  at 
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)  at 
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)  at 
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)  at 
java.net.Socket.connect(Socket.java:529) at 
com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1277] [SQLState 08S01] Login timeout for Connection to hyvm111  Tue Jan 07 14:26:10 IST 2014 socket orig=hyvm111 cid=8f4fb3 sess=0 java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)  at java.net.Socket.connect(Socket.java:529) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)  at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)  at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94)  at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)  at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:582)  at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.teradata.geo.TDGeoExport.makeConnection(TDGeoExport.java:709) at com.teradata.geo.TDGeoExport.main(TDGeoExport.java:736) Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)
Connecting to database failed.
===========================================
Data exporting failed!

The following figure shows a stack trace in which a user does not exist on the database.

Stack Trace Example