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)

Symptom

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>

Environment

  • 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.

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

Product

SAP Analytics Cloud 1.0