SAP Knowledge Base Article - Public

3122409 - Error "the data action could not be saved " in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error message occurs when you try to save a data action in SAP Analytics Cloud for Planning (SAC):

  • the data action could not be saved

In F12 -> network tab, you see the following error:

  • {"message":"An unexpected technical error occurred and has been logged.","stack":"","errorDetails":[{"messageId":"INTERNAL_TECHNICAL_ERROR","message":"An unexpected technical error occurred and has been logged.","bUIMessage":false,"bWarning":false},{"message":"dberror(Connection.prepareStatement): 257 - sql syntax error: unterminated quoted string literal: line 70 col 96 (at pos 4973)","bUIMessage":false,"bWarning":false}],"status":500,"bUIMsg":false,"bWarning":false}

This data action can be validated without any error.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.14.15

Cause

This is a code bug.

The root cause is that the dimension member used in the advanced formula contains character "$".

Resolution

The fix will be included in 2022.01.

As a workaround, please avoid using the dimension member which contains "$" in the ID.

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, advanced formula, script
, KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud 1.0