SAP Knowledge Base Article - Public

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


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


  • 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


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


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


SAP Analytics Cloud 1.0