SAP Knowledge Base Article - Public

2785188 - Data Action could not be saved error in SAP Analytics Cloud

Symptom

The following error occurs when saving a Data Action in SAP Analytics Cloud (SAC):

  • Data Action could not be saved.

The following error also occurs in the System > Monitor > Trace tab:

  • Exception@/sap/fpa/services/core/system/Exception.xsjslib:137 InternalErrorException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1024 _handleException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1311 PlanningSequence.prototype.setData@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:418 updateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:718 updateObject@/sap/fpa/services/bo/EpmObjectManager.xsjslib:1618 callRPC@/sap/fpa/services/GetResponse.xsjslib:140 handleRequest@/sap/fpa/services/GetResponse.xsjslib:288 main@/sap/fpa/services/GetResponse.xsjslib:367 @/sap/fpa/services/GetResponse.xsjs:2 Cause: An unexpected technical error occurred and has been logged. Exception@/sap/fpa/services/core/system/Exception.xsjslib:122 InternalErrorException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1024 _handleException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1311 PlanningSequence.prototype.setData@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:418 updateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:718 updateObject@/sap/fpa/services/bo/EpmObjectManager.xsjslib:1618 callRPC@/sap/fpa/services/GetResponse.xsjslib:140 handleRequest@/sap/fpa/services/GetResponse.xsjslib:288 main@/sap/fpa/services/GetResponse.xsjslib:367 @/sap/fpa/services/GetResponse.xsjs:2 Previous: dberror(Connection.prepareStatement): 257 - sql syntax error: incorrect syntax near "(": line 15 col 41 (at pos 1987) Statement@/sap/fpa/services/core/db/Connection.xsjslib:743 Connection.prototype.prepareStatement@/sap/fpa/services/core/db/Connection.xsjslib:883 PlanningScriptManager.prototype._createStoredProcedure/<@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:222 PlanningScriptManager.prototype._createStoredProcedure@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:208 PlanningScriptManager.prototype._create@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:166 PlanningScriptManager.prototype.update@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:129 ScriptStep.prototype.onUpdate@/sap/fpa/services/planSeq/steps/script/ScriptStep.xsjslib:59 PlanningSequence.prototype.prepareSave/<@/sap/fpa/services/planSeq/PlanningSequence.xsjslib:117 PlanningSequence.prototype.prepareSave@/sap/fpa/services/planSeq/PlanningSequence.xsjslib:117 PlanningSequence.prototype.setData@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:337 updateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:718 updateObject@/sap/fpa/services/bo/EpmObjectManager.xsjslib:1618 callRPC@/sap/fpa/services/GetResponse.xsjslib:140 handleRequest@/sap/fpa/services/GetResponse.xsjslib:288 main@/sap/fpa/services/GetResponse.xsjslib:367 @/sap/fpa/services/GetResponse.xsjs:2

Environment

  • SAP Analytics Cloud 2019.8

Cause

The dimension description or ID contains a bracket / parentheses character []().

Resolution

This issue is resolved in Q2 2019 (2019.8).

Workaround:

Remove brackets / parentheses characters []() from the dimension referenced in the Data Action.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, data actions, Data Action using Step advanced formula cannot be saved , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0