SAP Knowledge Base Article - Public

3008773 - Error "Error during executing SQL statement" encountered when save a public dimension after adding a custom property in SAP Analytics Cloud (SAC)


Add a custom property to a public dimension, then save, got below error:

InternalError: dberror(PreparedStatement.executeUpdate): 2048 - column store error: <?xml version="1.0" encoding="utf-8"?><createCubeResult version="1.0"><status><message>Error during executing SQL statement</message><errorCode>2116</errorCode></status>


  • SAP Analytics Cloud (Enterprise) 2021.1.1

Reproducing the Issue

  1. Login to customer system.
  2. Open the public dimension with issue.
  3. Add a custom property.
  4. Save the dimension, notice that the error occurred.


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 , Model, Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0