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 ONE Support launchpad (Login required).

Search for additional results

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