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

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

• SAP Analytics Cloud 2019.8

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

This issue is resolved in Q2 2019 (2019.8).

Workaround:

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

• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

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

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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem