SAP Knowledge Base Article - Preview

2875376 - Exception 42111 in GEO Map Story based on HANA Live Connection in SAP Analytics Cloud(SAC) & Digital Boardroom

Symptom

The following errors occur when creating a GEO map story based on HANA Live connection:

Error Warning Dialog:

  • Caught exception : exception 42111: SQL Error: search table error@
    [30423] instantiation of calculation model failed; exception 306106:
    Undefined variable: `...`
    Variable is marked as required but not set in the query exception 42111: SQL Error : search table error: [30423] Instantiation of calculation model failed; exception 306106: 
    Undefined variable: `...` 
    Variable is marked as required but not set in the query

Console logs:

  • [Error] Server: Caught exception ; Invalid SQL AP definition
    Caught exception: exception 42111: SQL errror: search table error [34023]
    Instantiation of calculation model failed; exception 306106:
    Undefined variable: `...` 
    Variable is marked as required but not set in the query


Read more...

Environment

  • SAP Analytics Cloud 2020.1.2

Product

SAP HANA, platform edition 2.0

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-LDC , SAC Live Data Connection , HAN-DB , SAP HANA Database , 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.