Troubleshooting - Geospatial Utilities

Teradata Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2519
lifecycle
previous
Product Category
Teradata Tools and Utilities

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!

Figure 9 shows a stack trace in which a user does not exist on Teradata Database.

Figure 9: Stack Trace Example

Troubleshoot issues with SET and MULTISET tables:

D:\RAJU\GeoSpatial\bin>java -classpath .;terajdbc4.jar; tdgssconfig.jar; com.teradata.geo.TDGeoImport -l hyvm111/ab2,ab2 -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
Logon       = hyvm111/ab2,ab2
Data Source = D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
connecting to hyvm111 ... connected!
Validating layer: SOIL_IA_REJECTED_SEQ
All layers successfully validated.
-------------------------------------------
Importing layer SOIL_IA_REJECTED_SEQ to table SOIL_IA_REJECTED_SEQ... (427/427)
===========================================
Data importing finished successfully!
Importing time is 61.266
Bteq out shows as follows:
BTEQ -- Enter your SQL request or BTEQ command:
show table ab2.SOIL_IA_REJECTED_SEQ;
show table ab2.SOIL_IA_REJECTED_SEQ;
*** Text of DDL statement returned.
*** Total elapsed time was 1 second.
---------------------------------------------------------------------------
CREATE SET TABLE ab2.SOIL_IA_REJECTED_SEQ ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO  (
      AREASYMBOL VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
      SPATIALVER FLOAT,
      MUSYM VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC,
      MUKEY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
      GEOM SYSUDTLIB.ST_Geometry)
PRIMARY INDEX ( AREASYMBOL );
BTEQ -- Enter your SQL request or BTEQ command:
sel count(*) from ab2.SOIL_IA_REJECTED_SEQ;
sel count(*) from ab2.SOIL_IA_REJECTED_SEQ;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
   Count(*)
-----------
         91
Case 2: Database used is ab and -m option data files are from D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected.
D:\RAJU\GeoSpatial\bin>java -classpath .;terajdbc4.jar; tdgssconfig.jar; com.teradata.geo.TDGeoImport
-l hyvm111/ab,ab -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected -m
Logon       = hyvm111/ab,ab
Data Source = D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
connecting to hyvm111 ... connected!
Validating layer: SOIL_IA_REJECTED_SEQ
All layers successfully validated.
-------------------------------------------
Importing layer SOIL_IA_REJECTED_SEQ to table SOIL_IA_REJECTED_SEQ... (427/427)
===========================================
Data importing finished successfully!
Importing time is 105.641
Bteq out shows as follows:
BTEQ -- Enter your SQL request or BTEQ command:
show table ab.SOIL_IA_REJECTED_SEQ;
show table ab.SOIL_IA_REJECTED_SEQ;
*** Text of DDL statement returned.
*** Total elapsed time was 1 second.
---------------------------------------------------------------------------
CREATE MULTISET TABLE ab.SOIL_IA_REJECTED_SEQ ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO (
      AREASYMBOL VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
      SPATIALVER FLOAT,
      MUSYM VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC,
      MUKEY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
      GEOM SYSUDTLIB.ST_Geometry)
PRIMARY INDEX ( AREASYMBOL );
 
BTEQ -- Enter your SQL request or BTEQ command:
sel count(*) from ab.SOIL_IA_REJECTED_SEQ;
sel count(*) from ab.SOIL_IA_REJECTED_SEQ;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
   Count(*)
-----------
        427