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

RS_HCPR_MODEL121 - Overview

• 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.