Skip to Content

Error creating ST_GEOMETRY type SAP DBTech JDBC: [2048]: column store error: add attribute error: [2999] general error (no further information available)

Has anyone seen this error before when simply trying to alter a table via SQL and add a column of type ST_GEOMETRY?

My SQL statement is: ALTER TABLE "TABLE1"."DIM_LATLONG" ADD ("LOCATION" ST_GEOMETRY(3857));

And it throws the following error:

Could not execute 'ALTER TABLE "TABLE1"."DIM_LATLONG" ADD ("LOCATION" ST_GEOMETRY(3857))' in 119 ms 400 µs .

SAP DBTech JDBC: [2048]: column store error: add attribute error: [2999] general error (no further information available)

I can't seem to find any information on this specific issue and the error message is not really helpful whatsoever.

Schema in Hana Cloud Platform

HANA Studio version 2.2.12

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Apr 02, 2016 at 06:17 PM

    Hi Shane,

    what special Spatial Reference ID 3857 you are using. Is that installed on your system.

    Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

    • I ended up creating a new table with definition of the ST_GEOMETRY column included. I then copied all of the data from the original table into the new one and populated the location dimension without any issues. Something i guess was causing issues with the original table but a new table fixed it! Thanks for your help on this.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.