SAP Knowledge Base Article - Public

3128225 - Memory issues when doing planning operations in SAP Analytics Cloud


  • When you try to publish your data changes in SAP Analytics Cloud you receive a message that an operation on a version failed because it is too large or that an unexpected technical error occurred, with the message possibly only appearing after a longer delay.
  • When you try to run a data action in SAP Analytics Cloud you receive a message that not enough resources are available.
  • When you try to perform a planning operation on a table in SAP Analytics Cloud (like data entry or copy-paste cells), you receive a message that an operation on a version failed because it is too large, or error message :"an unexpected technical error occurred".


SAP Analytics Cloud


The error occurs due to internal memory limitations. Several factors contribute to the memory required to successfully perform an operation and several factors influence the available memory in the system.

For publish, generally the memory required can increase with the following conditions:

  • The number of records in the base version
  • The number of changed records
  • The number of deleted records
  • The total number of records stored in the model fact table (in all public versions together)
  • and the number of base measures (even if they are sparsely booked).

The complexity of a scenario can influence the required memory as well. This includes, for example, data access control policies, data locking, validation rules, and auditing.

For data actions, the memory-need highly depends on the design of their customer-defined logic as well as the size of the input (i.e. the version it operates on).

The available memory in the system depends on multiple factors including the load on the system due to (concurrent) queries, the load due to data import and export jobs, the number of active private versions, and more.   



There is a setting in the "data and performance" section of the model preferences to configure a limit / override a default parameter that will lead to warnings when private versions or public edit versions are created that exceed the limit.

In cases where there is a lack of overall system memory, it can help to delete other not needed versions. If the edit state of a version is too big in itself, operations like publish may also reach operation-specific limits independent of the overall system memory available. In that case, it might be necessary to undo changes in the version history. If the version is so large that this is no longer possible and it has become generally unusable, it is recommended to revert (for public edits) or delete (for private versions) the version. If there is important data in the version that needs to be saved, it is recommended to copy relevant parts of the version with the "Choose which data to copy" option.

In cases where there are a large number of sparsely booked measures, consider redesigning the model and store values in more generic measures or booked on additional dimension members.

To prevent issues with too large versions in future:

  • rethink data action designs so that the data actions create less records
  • work with version copies that only include a filtered part of the data ("Choose which data to copy" option in the copy-version dialog)
  • configure the usage of planning areas in the model settings
  • generally, re-consider the model design choices so that the versions of the model are smaller

See Also

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


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, Unexpected error when publishing data back into a planning model. SAC, error , KBA , LOD-ANA-PL-DA , Data Actions , Problem


SAP Analytics Cloud 1.0