Symptom
Warning "There are &1 data cells. The export might take some time or even fail. Do you want to proceed?" when export to Excel from an Asset Accounting Fiori report.
Application runs into error: "Message not found (in main memory)".
Environment
- SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the Asset History Sheet report.
- Start an export to Excel; the export does not complete successfully: "Message not found (in main memory)"
Cause
The export exceeds memory limits due to too many cells in the result set. This can also occur for background exports. Removing subtotals may not be sufficient if the overall cell count remains high.
The Excel export was not designed for mass-data download. Its purpose is to offer a human-readable offline version of the report, it's not designed as a data-extraction tool.
Resolution
In case too much data need to be export, try to reduce the amount by filtering (e.g. Asset Class), and then combining the results manually in Excel.
See Also
Keywords
asset history sheet, export, excel download, export failure, memory limit, too many cells, large dataset, background export, asset accounting, report export, s/4hana cloud, public edition, excel export error, data volume, cell limit , KBA , FI-AA-AA-C-2CL , Transactions (Public Cloud) , Problem
SAP Knowledge Base Article - Public