Skip to Content

ST_GEOMETRY: XML truncated

Mar 27 at 11:16 AM


avatar image


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.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ingo Peter
Mar 28 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

10 |10000 characters needed characters left characters exceeded