Skip to Content

HCP / Spatial / SRID Conversion / TrexUpdate failed


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

table.png (1.2 kB)
table-content2.png (27.4 kB)
table-create.png (5.3 kB)
insert.png (6.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 07, 2017 at 06:44 PM

    Hello Leonardo,

    Can you try this,

    CREATE COLUMN TABLE CDR_3857(<fields>,


    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'.



    I have not tried this INSERT though :)

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 07:22 PM

    Thank you Benedict! Now it works!

    Add comment
    10|10000 characters needed characters exceeded