SAP Knowledge Base Article - Public

2811544 - Error "An unexpected technical error occurred and has been logged." after executing data action" occurs after executing data action in SAP Analytics Cloud

Symptom

  • When running a data action in SAP Analytics Cloud (SAC) to check if some cells are empty, it hangs for some time and then get this error:
    • An unexpected technical error occurred and has been logged. Please contact SAP for further assistance / SAP Delivered Support.
  • In the system trace, this message is displayed on component sap.fpa.services.resource.planSeq
    • Execution of EPM command failed. The error has been logged.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Execute data action using trigger in the story.
  2. the system hangs for a while and error message is reported.

Cause

  • Issue is caused by memory exhaustion due to a large dataset.
  • Source data scope can rapidly expand to generate very large volumes of data if multiple dimensions exist, even if the individual members in each dimension are small for example:
    • Project * Company * Fiscal_Year * Journal * Product * Account * Currency * Code * Entity = 3 * 3 * 3 * 404 * 25 * 278 * 4 * 1116 * 13 = 4.39944E+12.
  • Data actions that are not correctly limited in such cases will cause an excessively large load from backend and result in the error "An unexpected technical error occurred and has been logged".

Resolution

  • Effective use of MEMBERSET statements defined in advanced data actions are recommended to filter source data to be copied to only include dimension members filtered by MEMBERSET.
  • This reduces the usage of your system capacity, like memory allocation or peak memory, and thus helps to enhance system performance.
  • We recommend you Define as many MEMBERSET statement as possible.
  • You can also find Help documents for the Best Practice tips for Performance.

See Also

Keywords

data action, SAC, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, EPM command an unexpected technical error occurred when processing data action  on version  , KBA , is running , the versions is in use. please try again , please try again later. , the version is in use , not able to run data action because anot , error sac kba data actions data action , data action because another operation is , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud 1.0