How To Fix RSRCACHE020 - Size from which entries are to be written to larger persistence

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRCACHE - Messages for OLAP Cache

• Message number: 020

• Message text: Size from which entries are to be written to larger persistence

What causes this issue?

The cache mode "Query Aggregate" uses a cluster table and BLOB storage
(table with XSTRING area) to store cache entries with query data. This
setting specifies the size limit up to which the system is to write to
the memory area for smaller query results and when it is to use the
memory area for larger data.
Using the following two settings, you can specify which of the memory
areas is to be used for the query results that are larger than the key
figure specified here.
You specify which memory area is to be used when you create the cache
entry for the query data; once specified, this value cannot be changed,
even if the cache entry is later larger than the predefined key figure.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRCACHE020 - Size from which entries are to be written to larger persistence ?

  The SAP error message RSRCACHE020 typically indicates an issue related to the resource cache in the SAP system, specifically concerning the size of the entries that are being written to a larger persistence layer. This error can occur in various contexts, such as when dealing with the SAP BW (Business Warehouse) or other SAP applications that utilize caching mechanisms.
  Cause:
  The error message RSRCACHE020 is generally triggered when the system attempts to write entries to a persistence layer, but the size of the entries exceeds the defined limits or thresholds. This can happen due to several reasons, including:
  
  Configuration Issues: The settings for the resource cache or persistence layer may not be properly configured, leading to size mismatches.
  Data Volume: The volume of data being processed may be larger than what the system can handle at once, especially if there are large datasets being loaded or processed.
  Memory Limitations: The system may be running low on memory or resources, which can affect its ability to handle larger entries.
  Version Compatibility: There may be compatibility issues between different versions of SAP components or between the application and the database.
  
  Solution:
  To resolve the RSRCACHE020 error, you can take the following steps:
  
  
  Check Configuration: Review the configuration settings for the resource cache and persistence layer. Ensure that the size limits are set appropriately for your data volume.
  
  
  Adjust Data Load: If you are loading large datasets, consider breaking them into smaller chunks to avoid exceeding size limits.
  
  
  Monitor System Resources: Check the system's memory and resource usage. If the system is low on resources, consider increasing the available memory or optimizing the workload.
  
  
  Update SAP Components: Ensure that all relevant SAP components are up to date. Sometimes, applying the latest patches or updates can resolve compatibility issues.
  
  
  Review Logs: Check the system logs for any additional error messages or warnings that may provide more context about the issue.
  
  
  Consult Documentation: Refer to SAP documentation or notes related to the specific version of the software you are using. There may be specific recommendations or known issues related to RSRCACHE020.
  
  
  Contact SAP Support: If the issue persists after trying the above solutions, consider reaching out to SAP support for further assistance. They can provide more detailed troubleshooting based on your specific system configuration and usage.
  
  
  Related Information:
  
  SAP Notes: Search for SAP Notes related to RSRCACHE020 for any specific fixes or recommendations provided by SAP.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Performance Tuning: Consider performance tuning for your SAP system to optimize resource usage and improve overall efficiency.
  
  By following these steps, you should be able to diagnose and resolve the RSRCACHE020 error effectively.