Skip to Content

Error with ESRI Shapefiles in Hana Studio

Hi,

Trying to import a shapefile using Hana Studio 2.0.7, I always get the following error:

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [2]: general error: ShapefileImport: inconsistent datatype: Failed to parse from WellKnownText

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345)

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185)

at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:102)

at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1030)

at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:820)

at com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:896)

at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:945)

at com.sap.db.jdbc.StatementSapDB.execute(StatementSapDB.java:256)

at com.sap.db.jdbc.StatementSapDB.execute(StatementSapDB.java:228)

at com.sap.db.jdbc.trace.Statement.execute(Statement.java:132)

at com.sap.ndb.studio.jdbc.util.SQLExecutor$1.run(SQLExecutor.java:118)

I followed the prerequisite from this documentation http://help.sap.com/saphelp_hanaplatform/helpdata/en/6e/e89f6694244966bcd25f429840575e/content.htm

and I'm wandering if there is anything specific that needs to be done the shapefile. The shapefiles come from Arcgis for Desktop.

The error seems about a wrong WKT. I believe this is about the projection format which is a standard WGS84 Web Mercator: Maybe it is necessary to register the projections before importing?

Thanks for your help!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Apr 02, 2015 at 08:31 AM

    Hi Jean,

    Would you mind updating to HANA studio 2.0.11?

    Best regards,

    Candy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 10, 2015 at 08:54 AM

    Hello Jean,

    Would you please let me know the revision of your HANA DB?

    If it's lower than 93, you can try to upgrade it to 93 to have a try?

    Best regards.

    Janet

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2015 at 01:05 PM

    Hi Jean

    In SPS10 or SPS11 you will get a more detailed error message. I guess the problem is you are trying to import the data with the wrong spatial reference system (SRS). If you do not specify a SRS during import, we will use the default which is 0 (euclidean space) and your coordinates do not fit into the boundary anymore.

    In the latest studio version you can specify the SRS or you do it on the command line with the following command:

    IMPORT "TEST"."SHAPE" AS SHAPEFILE FROM '/stmp/shapes' WITH SRID 3857;

    Please note, that the SRS 3857 (Web Mercator ) must exists.

    Best

    Hinnerk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.