Skip to Content
avatar image
Former Member

ERROR caused by storing a point after a ST_Transform operation

Hi,

I have a problem in HANA when I try to transform and store in a column table a ST_POINT from 4326 SRID to 3857. The resulting error message is:

Could not execute 'create column table
ZZZ_TEST_CREATE_TRANSFORM as ( select CONTENITORE_ID, CONTENITORE_DES, ...' in 4.177 seconds . 

[129]: transaction rolled back by an internal error:TrexUpdate failed on table 'HER_LI:ZZZ_TEST_CREATE_TRANSFORM' with error:commitOptimizeAttributes() failed with rc=1610088, message not found; table 'HER_LI:ZZZ_TEST_CREATE_TRANSFORM$delta_1$', rc=1610088 - enforce TX rollback  <br>

The query that produce this error is:

create column table ZZZ_TEST_CREATE_TRANSFORM as (
select 
  CONTENITORE_ID,
  CONTENITORE_DES,
  LATITUDINE,
  LONGITUDINE,
  NEW ST_POINT('POINT(' || LATITUDINE || ' ' || LONGITUDINE || ')', 4326).ST_Transform(3857) as POINT
from HER_LI.WT_TEST_MODEL_DIM );

I try to execute only the select state and the query produce a results without error.

Any one have the same problem? Any suggestion?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers