SAP Knowledge Base Article - Public

3049506 - Exception 42111: SQL Error when changing parameter values of a Hana view in SAP Analytics Cloud (SAC)

Symptom

When changing the value of a Hana view parameter, it throws the error "Exception 42111: SQL Error"

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2.15

Reproducing the Issue

  1. Create a new story based on a Hana view that has parameters
  2. Click on {} and select the view to change parameter values
  3. Click the X to remove the value for the parameter
  4. Click the squares to choose a new value
  5. Get the error

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

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, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0