Skip to Content
0

ERROR caused by storing a point after a ST_Transform operation

Jan 24, 2017 at 03:27 PM

83

avatar image

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

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

0 Answers