Having too many cache entries on the system can be problematic as they may have a negative impact on the query performance. In the past you have used the report RSR_CACHE_RSRV_CHECK_ENTRIES to delete old OLAP cache entries from the tables.
You even may have created a batch job to regularly delete old entries with this report. Since the upgrade to BW 7.4 the report does not delete the entries anymore. Therefore, for instance table RSR_CACHE_DATA_B is growing to a critical size.
- SAP NetWeaver 7.4
RSR_CACHE _QUERY, RSR_CACHE_VARSH_B, RSR_CACHE_FFB, RSR_CACHE_DATA_B, RSR_CACHE_DATA_C, Enqueue , KBA , BW-BEX-OT-CCH , Olap Cache , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.