SAP Knowledge Base Article - Public

2989464 - "An unexpected technical error occurred and has been logged." in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error occurs in SAP Analytics Cloud for Planning (SAC) when you run a data action:

  • An unexpected technical error occurred and has been logged.

In the Monitor -> Trace, the full stack is as below:

  • An unexpected technical error occurred and has been logged. InternalErrorException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1834 _handleException@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:2322 PlanningSequence.prototype.execute@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1170 callFunction@/sap/fpa/services/bo/EpmObjectManager.xsjslib:2408 RpcObject.prototype._callRpc@/sap/fpa/services/core/rest/RestUtil.xsjslib:72 RpcObject.prototype.invoke@/sap/fpa/services/core/rest/RestUtil.xsjslib:26 handleRequest@/sap/fpa/services/GetResponse.xsjslib:175 main@/sap/fpa/services/GetResponse.xsjslib:216 @/sap/fpa/services/GetResponse.xsjs:9 Statement@/sap/fpa/services/core/db/DbStatement.xsjslib:61 Connection.prototype.prepareStatement@/sap/fpa/services/core/db/DbConnection.xsjslib:252 ScriptStepGenerator.prototype._getRestMembersOfDimension@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:1333 ScriptStepGenerator.prototype._setExcludingMembers/<@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:1301 ScriptStepGenerator.prototype._setExcludingMembers@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:1293 ScriptStepGenerator.prototype._setExcludingMembersInformationFromScope@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:1258 ScriptStepGenerator.prototype._getScriptScope@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:1153 ScriptStepGenerator.prototype._getReferenceDataCopyFilter@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:1472 ScriptStepGenerator.prototype._addCopyReferenceDataOperation@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:2905 ScriptStepGenerator.prototype._addAlgorithm@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:2763 ScriptStepGenerator.prototype.generate@/sap/fpa/services/planSeq/generator/steps/script/ScriptStepGenerator.xsjslib:149 PlanningSequenceModelGenerator.prototype.processScriptStep@/sap/fpa/services/planSeq/generator/PlanningSequenceModelGenerator.xsjslib:150 ScriptStep.prototype.handleVisitor@/sap/fpa/services/planSeq/steps/script/ScriptStep.xsjslib:54 PlanningSequence.prototype.handleVisitor/<@/sap/fpa/services/planSeq/PlanningSequence.xsjslib:175 PlanningSequence.prototype.handleVisitor@/sap/fpa/services/planSeq/PlanningSequence.xsjslib:175 PlanningSequence._executeValidatedSequence@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1646 PlanningSequence.prototype.execute@/sap/fpa/services/planSeq/PlanningSequenceManager.xsjslib:1140 callFunction@/sap/fpa/services/bo/EpmObjectManager.xsjslib:2408 RpcObject.prototype._callRpc@/sap/fpa/services/core/rest/RestUtil.xsjslib:72 RpcObject.prototype.invoke@/sap/fpa/services/core/rest/RestUtil.xsjslib:26 handleRequest@/sap/fpa/services/GetResponse.xsjslib:175 main@/sap/fpa/services/GetResponse.xsjslib:216 @/sap/fpa/services/GetResponse.xsjs:9

In F12 -> Console, you see the following errors:

  • POST https://.../sap/fpa/services/rest/epm/objectmgr?tenant=2 500
    error - 500 - error

In F12 -> Network, request objectmgr?tenant=2 returns code 500:

  • {"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: incorrect syntax near \"WHERE\": line 1 col 28 (at pos 28)","bUIMessage":false,"bWarning":false}],"status":500,"bUIMsg":false,"bWarning":false}

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.29

Reproducing the Issue

  1. Run a data action.

Cause

One dimension does not have any hierarchies maintained but the "Allow hierarchies with a subset of members" option is enabled.

Resolution

Disable "Allow hierarchies with a subset of members" setting of that dimension.

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 , KBA , LOD-ANA-PL-AF , Advanced Formulas , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud 1.0