BW 3.1C SP Upgrade from 9 to 16 caused error in web reports

[Former Member]

Hi,

We have just installed support packages for BW 3.1C from SP9 to SP16. After the installation of support packages 10 to 16, we encounter the following errors in BEx Analyser, BEx Query designer as well as Web Application Designer for all the existing web reports:

<b><i>An exception with the type CX_RSR_CACHE_ERROR occurred, but was neither

h

The exception occurred (program: CL_RSR_CACHE_QUERY_CUBE_MEM===CP, incl</i></b>

Next, I debugged the web reports via RSRT. If I choose "Do not use cache", then those web reports works fine. However, when I use default i.e. use cache, then the above errors occur.

Would appreciate very much, if anyone could give me some advices/fixes.

Thanks in advance.

Best Regards,

Lye

[Former Member]

Normally I'd suggest to send these messages to SAP. Any error in a SP should be sent to SAP because other users might get the same problem. But I'd first try to delete the Cache in RSRT to see if the problem still remains.

Best regards

Dirk

[Former Member]

Dirk,

I have tried to delete cache via RSRT before but unsuccessful. Found the solution.

The solution is to switch the query properties in transaction

RSRT -> properties ->

a) Cache Mode 2 Main Memory Cache With Swapping

b) Persistence Mode 2 Cluster Table

to

a) Cache Mode 0 Cache is Inactive

and back to

a) Cache Mode 2 Main Memory Cache With Swapping

b) Persistence Mode 2 Cluster Table

After doing that it fixed the problem.

Thanks.

Regards,

Lye

[Former Member]

Solution posted.