Question Re: HCP / Spatial / SRID Conversion / TrexUpdate failed in Technology Q&A

HCP / Spatial / SRID Conversion / TrexUpdate failed

Former Member — Tue, 07 Mar 2017 15:26:56 GMT

Hi,

I have an HCP Hana istance. We loaded a shape file in a table using 3044 SRID (which is the SRID used in the GIS system).

Then we need to convert the SRID from 3044 to 3857. So we first created a table

and then perform an insert

but an error is returned and it seems an OOM (Out of Memory) problem or a bug with HANA

Could not execute 'insert into CDR_3857 select OBJECTID, IDSAP, DENOMINAZI, WA_LATITUD, WA_LONGITU, ...' in 40 ms 456 µs . [129]: transaction rolled back by an internal error: TrexUpdate failed on table 'HER_LA:CDR_3857' with error: commitOptimizeAttributes() failed with rc=1610088, message not found; table 'HER_LA:CDR_3857$delta_1, rc=1610088 - enforce TX rollback

Suggestions? Already happened to some of you?

Thank you

Re: HCP / Spatial / SRID Conversion / TrexUpdate failed

BenedictV — Tue, 07 Mar 2017 18:44:47 GMT

Hello Leonardo,

Can you try this,

CREATE COLUMN TABLE CDR_3857(<fields>,

SHAPE ST_GEOMETRY(3857));

Mention the SRID when you specify the geometry type. Provided the SRID is available in your system. If you dont provide the SRID it will default to '0'.

Also,

INSERT INTO CDR_3857 SELECT <fields>, SHAPE.ST_SRID(3044).ST_TRANSFORM(3857)

I have not tried this INSERT though 🙂

Re: HCP / Spatial / SRID Conversion / TrexUpdate failed

Former Member — Tue, 07 Mar 2017 19:22:07 GMT

Thank you Benedict! Now it works!