SAP Note 860013 - Query cannot use cache -missing query name in cache

Component : Analyzing Data - OLAP Technology

Solution : https://service.sap.com/sap/support/notes/860013 (SAP Service marketplace login required)

Summary :
When executing a query, a termination error X299(BRAIN) occurs because the system cannot retrieve the saved data from the OLAP cache. This is due to a misalignment in the cache's "Query Directory," where the query names are missing, preventing cache entries from being correctly linked to their corresponding queries. This issue arises from simultaneous query access altering the "Query Directory." A complete solution requires redesigning the OLAP cache mechanism, but a temporary mitigation can be achieved through specific Support Packages (SP28 for BW 3.0B, SP22 for BW 3.10, and SP14 for BW 3.50).

Key words :
sapbwnews bw sp14 netweaver'04 stack 14, 0b            import support package 28, 10 content            import support package 22, query/cache entry assignment, safe source code, extensive design change, 50            import support package 14, cache easily accessible, cache source code, 0b support package 28

Related Notes :

1107434OLAP cache consultation: Long wait times due to locks
959405Cache enqueues are not set
935656Cache enqueue attempts cause performance problems
856226Logging mechanism to analyse Cache related problems
836439SAPBWNews BW Support Package 14 NW'04 Stack 14 RIN
807967Filling the cache from the Reporting Agent
783252SAPBWNews BW 3.1 Content Support Package 22
783170SAPBWNews BW 3.0B Support Package 28