Troubleshoot JDBC with the Stack - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
ygh1641301476787.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2519
Product Category
Teradata Tools and Utilities

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

C:\Program Files\Teradata\Client\17.20\bin>java -Xms256m -Xmx1024m com.teradata.geo.TDGeoExport -l ABC/geouser,geouser -t customers -f "ESRI Shapefile" point  -o C:\GeoSpatial\TestEnv\geodata -n customers
==============================================
= Teradata GeoExport  VERSION 17.20.00.00    =
=                                            =
= Copyright 2014-2022 Teradata.              =
= ALL RIGHTS RESERVED.                       =
==============================================
Coordinate System defaulting to NAD83.
WARNING: There is data in the directory C:\GEOSPATIAL\TESTENV\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        = ABC/geouser,****
LOGMECH      = TD2
DatabaseName = geouser
Table Name   = customers
Export to    = C:\GEOSPATIAL\TESTENV\GEODATA\customers
File Format  = ESRI Shapefile
Shape Type   = POINT
Only 1 Type  = FALSE
-------------------------------------------
connecting to ABC ...2022-05-20.22:17:10.042 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@77459877 Connection to ABC Fri May 20 22:17:10 IST 2022 socket orig=ABC cid=6276ae34 sess=0 java.net.UnknownHostException: ABC   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(Unknown Source)   at java.net.InetAddress.getAllByName0(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.doLookup(TDNetworkIOIF.java:238)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.getAddresses(TDNetworkIOIF.java:276)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:457)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:184)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createIO(TDNetworkIOIF.java:175)   at com.teradata.jdbc.jdbc.GenericTeradataConnection.<init>(GenericTeradataConnection.java:317)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:186)   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.ConnectionFactory.createConnection(ConnectionFactory.java:171)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:226)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:161)   at java.sql.DriverManager.getConnection(Unknown Source)   at java.sql.DriverManager.getConnection(Unknown Source)   at com.teradata.geo.TDGeoExport.makeConnection(TDGeoExport.java:811)   at com.teradata.geo.TDGeoExport.main(TDGeoExport.java:870)
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 17.10.00.27] [Error 1000] [SQLState 08S01] Login failure for Connection to ABC Fri May 20 22:17:10 IST 2022 socket orig=ABC cid=6276ae34 sess=0 java.net.UnknownHostException: ABC   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(Unknown Source)   at java.net.InetAddress.getAllByName0(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.doLookup(TDNetworkIOIF.java:238)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.getAddresses(TDNetworkIOIF.java:276)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:457)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:184)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createIO(TDNetworkIOIF.java:175)   at com.teradata.jdbc.jdbc.GenericTeradataConnection.<init>(GenericTeradataConnection.java:317)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:186)   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.ConnectionFactory.createConnection(ConnectionFactory.java:171)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:226)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:161)   at java.sql.DriverManager.getConnection(Unknown Source)   at java.sql.DriverManager.getConnection(Unknown Source)   at com.teradata.geo.TDGeoExport.makeConnection(TDGeoExport.java:811)   at com.teradata.geo.TDGeoExport.main(TDGeoExport.java:870)
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:95)
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:70)
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:208)
        at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:189)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createIO(TDNetworkIOIF.java:175)
        at com.teradata.jdbc.jdbc.GenericTeradataConnection.<init>(GenericTeradataConnection.java:317)
        at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:186)
        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.ConnectionFactory.createConnection(ConnectionFactory.java:171)
        at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:226)
        at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:161)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.teradata.geo.TDGeoExport.makeConnection(TDGeoExport.java:811)
        at com.teradata.geo.TDGeoExport.main(TDGeoExport.java:870)
Caused by: java.net.UnknownHostException: ABC
        at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
        at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)
        at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
        at java.net.InetAddress.getAllByName0(Unknown Source)
        at java.net.InetAddress.getAllByName(Unknown Source)
        at java.net.InetAddress.getAllByName(Unknown Source)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.doLookup(TDNetworkIOIF.java:238)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.getAddresses(TDNetworkIOIF.java:276)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:457)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:184)
        ... 13 more
Connecting to database failed.
===========================================
Data exporting failed!