Solution : https://service.sap.com/sap/support/notes/1030732 (SAP Service marketplace login required)
Summary :
When executing a query in SAP NetWeaver 2007 BI, a termination error CX_RSR_CACHE_ERROR occurs if duplicate session processing IDs (SPIDs) are detected by the _CHECK_SP method in the CL_RSR_CACHE_QUERY_CUBE_STORE class. This occurs due to incorrectly persisting SPIDs in the storage medium, which should instead be generated afresh for each session. To resolve, avoid writing SPIDs to the persistence medium and clear the cache regularly. Implement SAP Support Package SAPKW71002 following the guidelines in Note 1011773 or use the advanced correction instructions after consulting Note 875986.
Key words :
sap netweaver 2007 bi import support package 02, sap netweaver 2007 bi, online analytical processing, sap note assistant, cx_rsr_cache_error termination occurs, _check_sp method checks, call transaction snote, duplicate spids constitute, support package, 10 support package 02
Related Notes :
| 1107434 | OLAP cache consultation: Long wait times due to locks |
| 1105139 | Filling the OLAP cache with "contains pattern" in BI 7.0 |
| 1064099 | Uncaught exception during deletion of OLAP cache in RSRCACHE |
| 1053682 | OLAP cache: Enqueue deadlock in invalidation/parallelism |
| 1050089 | OLAP cache: Enqueue deadlock in extensive parallelism |
| 1011773 | SAPBINews NW BI 7.10 ABAP SP01 |