3597620 - Error in validating syntax of SQL expression for ST_POINT type calculated column in BAS

Symptom

The following error is reported while validating the syntax for calculated column of type ST_POINT:

Invalid expression
An error was detected close to line xx column xx ('|')

The following SQL expression is added for the calculated column expression: ST_Transform(ST_GeomFromText('POINT(' || "<long_column_name>" || ' ' || "<lat_column_name>" || ')', <srid>),<srid>)

Environment

SAP HANA Cloud

SAP Business Application Studio

Product

SAP Business Application Studio all versions ; SAP HANA Cloud all versions

Keywords

SAP HANA Cloud, spatial, Calculated Column, location point, calculation view, ST_POINT, syntax error, expression validator , KBA , HAN-BAS-EDT-MOD , Calculation View Editor in Business Application Studio , HAN-CLS-HC , HANA Cloud Services HANA Cloud , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.