SAP Knowledge Base Article - Public

2814170 - Error "Caught exception : exception 70002620: executor: plan operation failed" appears when adding one Geo Map on Geo Spatial Models from HANA Calculation Views in SAP Analytics Cloud (SAC)

Symptom

  • Error "Caught exception : exception 70002620: executor: plan operation failed" appears when adding one Geo Map on Geo Spatial Models from HANA Calculation Views  in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2019.8.16

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with Geo Map.
  3. Add one Bubble Layer on the problematic Geo Spatial Models from HANA Calculation Views.
  4. Add Location Dimension.
    => Error "Caught exception : exception 70002620: executor: plan operation failed" appears.
    => No location data is returned from HANA.

Cause

  • The type of Location Identifier in the fact table that contains analytic data,  doesn't match the type of Location Data identifier in the Location Data table.
    For example, one is CHAR and another one is NVARCHAR.
  • As a result, the calculation view that contains analytic data (based on fact table) will join the location Data view containing spatial data (based on location data table) on mismatched data-types, which is not supported by HANA MDS.

Resolution

Make the type of two location identifiers same in both fact table and Location Data table.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, HANA, Geo, Map, Spatial, location, 70002620, plan operation failed , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0