SAP Knowledge Base Article - Public

2799776 - "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:1018
    _handleException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1309
    PlanningSequence.prototype.setData@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:418
    updateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:733
    updateObject@/sap/fpa/services/bo/EpmObjectManager.xsjslib:1637
    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:1018
    _handleException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1309
    PlanningSequence.prototype.setData@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:418
    updateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:733
    updateObject@/sap/fpa/services/bo/EpmObjectManager.xsjslib:1637
    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): 387 - table ambiguously defined: T1: line 460 col 50 (at pos 30032)
    Statement@/sap/fpa/services/core/db/Connection.xsjslib:746
    Connection.prototype.prepareStatement@/sap/fpa/services/core/db/Connection.xsjslib:886
    PlanningScriptManager.prototype._createStoredProcedure/<@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:243
    PlanningScriptManager.prototype._createStoredProcedure@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:229
    PlanningScriptManager.prototype._create@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:187
    PlanningScriptManager.prototype.create@/sap/fpa/services/planningScript/PlanningScriptManager.xsjslib:137
    ScriptStep.prototype.onCreate@/sap/fpa/services/planSeq/steps/script/ScriptStep.xsjslib:48
    PlanningSequence.prototype.prepareSave/<@/sap/fpa/services/planSeq/PlanningSequence.xsjslib:116
    PlanningSequence.prototype.prepareSave@/sap/fpa/services/planSeq/PlanningSequence.xsjslib:116
    PlanningSequence.prototype.setData@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:337
    updateObjectEx@/sap/fpa/services/bo/EpmObjectManager.xsjslib:733
    updateObject@/sap/fpa/services/bo/EpmObjectManager.xsjslib:1637
    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.11

Cause

There is an issue when using multiple dimension filters in DATA function with same dimension's property.

For example, in DATA( [d/ACCOUNT] = [d/ORDER].[p/GLAccount] ,[d/COSTCENTRE] = [d/ORDER].[p/CostCentre] ,[d/COMPANYCODE] = [d/ORDER].[p/Company] ),
[d/ORDER] dimension is used with multiple properties.

Resolution

The fix will be included in Wave 2019.14, which is planned to be delivered in September.

As a workaround, you can change the configuration option CONFIG.GENERATE_UNBOOKED_DATA to OFF.

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, upgrade , 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