Skip to Content

ST_GEOMETRY: XML truncated


When I upload an ESRI shape file to HANA a table is generated where the shape-field has type ST_GEOMETRY. When I do a data preview of the table the contents of this field is shown as some xml with doctype SVG. Double-clicking that field shows you a dialog with two registers: MAP and XML.

Usually in MAP you see the shape of the geometry if this is a polygon. This does not work in my current system. A closer look at the XML tab shows that the XML does not close either. The string of numbers describing the edges of the polygon suddenly stops.

I tried to upload several times, also shape files which work pretty well in other HANA systems. This HANA system is an HXE 2.0 SP02. It seems as if the length of ST_GEOMETRY is limited.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 28, 2018 at 08:47 AM

    Update: Shape data seem to be complete because

    select shape.st_assvg() from <table> 

    shows a complete XML which can also be viewed as a shape. So the issue seems to be a viewing issue of the data preview.

    Rgs, Ingo

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 29, 2018 at 12:59 PM

    What IDE do you use for preview? E.g. in HANA Studio you need to change in Preferences --> SAP HANA --> Runtime --> Results --> Limit for LOB Columns and Limit for Zoom.

    Plus you need to be aware that rendering geometries with huge number of points can take really long time, or not return results at all.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Witalij,

      I used SAP HANA Studio 2 with the most recent patch (Revision 231.00 for SAP HANA STUDIO 2). I set the preferences as suggested, however the effect is still the same: The XML is truncated and ergo no shape can be shown.

      Thx, Ingo