How To Fix RS_HCPR_MODEL121 - Persistent OLAP cache is switched off because of PartProvider '&2'

SAP Error Message - Details

• Message type: E = Error

• Message class: RS_HCPR_MODEL - Messages related to the HANA Composite Provider Backend

• Message number: 121

• Message text: Persistent OLAP cache is switched off because of PartProvider '&2'

What causes this issue?

The CompositeProvider contains one or several joins. Only the leftmost
join partner of a join tree is visible to the analytic manager as an
InfoProvider for analysis of data integrity and possible update of cache
objects in the delta process.

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

In order to make the content of the providers visible to the analytic
manager for data updates, the analytic engine must be able to check and
control that the data content of the join partners has remained stable.
The InfoProvider in question does not supply any information about data
changes. The analytic manager is therefore not able to control and
guarantee stability and semantical correctness of cache entries.

System Response

The persistent query cache is switched off for queries on this
CompositeProvider.

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 RS_HCPR_MODEL121 - Persistent OLAP cache is switched off because of PartProvider '&2' ?

  The SAP error message RS_HCPR_MODEL121 indicates that the persistent OLAP cache is disabled for a specific PartProvider in your SAP BW (Business Warehouse) system. This can occur for various reasons, and understanding the cause and solution can help you resolve the issue.
  Cause:
  
  Configuration Issues: The persistent OLAP cache may be disabled due to configuration settings in the PartProvider. This could be due to the PartProvider not being set up correctly to support caching.
  Data Model Changes: If there have been recent changes to the data model or the underlying InfoProvider, it may lead to the cache being disabled.
  Performance Issues: Sometimes, the system may disable the cache if it detects performance issues or inconsistencies in the data.
  System Settings: The overall system settings for caching may not be configured to allow persistent OLAP caching for certain types of queries or InfoProviders.
  
  Solution:
  
  Check PartProvider Configuration: Review the configuration of the PartProvider mentioned in the error message. Ensure that it is set up correctly to allow for persistent OLAP caching.
  Re-enable Caching: If caching has been disabled, you may need to re-enable it. This can typically be done in the settings of the InfoProvider or the query.
  Review Data Model Changes: If there have been recent changes to the data model, ensure that they are compatible with persistent OLAP caching. You may need to revert or adjust these changes.
  Monitor Performance: Check for any performance issues that may have led to the cache being disabled. Address any underlying issues that could be affecting performance.
  Consult Documentation: Refer to SAP documentation or notes related to persistent OLAP caching and the specific PartProvider to understand any additional requirements or settings.
  System Administration: If you are unable to resolve the issue, consider reaching out to your SAP Basis or BW administrator for assistance. They may have access to logs and system settings that can provide further insights.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can share their solutions.
  Performance Tuning: Consider reviewing best practices for performance tuning in SAP BW, as this can help prevent issues related to caching in the future.
  
  By following these steps, you should be able to identify the cause of the RS_HCPR_MODEL121 error and implement a solution to re-enable the persistent OLAP cache for the specified PartProvider.