SAP Knowledge Base Article - Preview

2907987 - BW-Live spatial error: exception 1601801: PROJ.4 transformation error: latitude or longitude exceeded limits at "st_transform" function

Symptom

The correspondent business scenario, from the technical point of view, requires an SAP Analytics Cloud Story to be built.
It is wanted to use GEO map with Custom Choropleth layer in order to leverage from the benefiits of creating Self-Created Region Characteristics with Self-Uploaded Shapes, that are origanized in Self-Defined hierarchical Arrangement of the Regions.

In case of customer shapes, the main source of Geo data is the shapes itselfs, that have been created in for example ArcGIS. The shapes are needed to be uploaded to the Business Document Service (BDS). it is needed to be done transaction RSDIOBJGISMAINT.
Shapedata comes in (at least) triples:

Region.dbf: DBase file contains a table with Attributes describing Regions
Region.shp: Shapefile containing all geographic Shapes
Region.shx: Link between Shape and DBase File

All the transformations and geographical calculations happen in HANA. So for processing the SPATIAL engine of HANA is used, this means that to have a good perfromance, we want all the GEO data in GEO format, so HANA can work with it right away. Therefore after the shapes are uploaded to the Business Document Service, the Geo data is still needed to be transformed to the HANA Spatial format by selecting option "Update Geotable used during reporting". During the update process, error occurs:

Error Update Task for geotable cancelled due to errors.
Information Shapefile xyz.shp has been loaded.
Error spatial error: exception 1601801: PROJ.4 transformation error: latitude or longitude exceeded limits at "st_transform" function
Error Execution of method EXECUTE_UPDATE failed
Error Updating the geotable through a BW temp table has failed.


Read more...

Environment

  • SAP Analytics Cloud 2020.7 and upwords
  • SAP BW/4HANA 2.0 SP4

Product

SAP Analytics Cloud 1.0 ; SAP BW/4HANA 2.0

Keywords

longitude, latitude, 4326, "Spatial Reference ID" , KBA , BW-BEX-OT-BICS-INA , BW INA provider , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW4-AE-API-INA , INA (Information Access Protocoll) , How To

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.