Query executes in RSRT but not in BEx Analyzer

[Former Member]

Hi Everyone,

I have a query for an infocube and ods object, in the bex analyzer for the infocube the query executes which has around 5000 records but for the ods object which has also 5000 records comes up with this error.

<b>An exception with the type CX_SY_EXPORT_NO_SHARED_MEMORY occurred, but was

neither handled locally, nor declared in a RAISING

Message no. RS_EXCEPTION000</b>

when I execute the query in RSRT it comes up.

After closing and re logging into bex analyzer executes the query for the first but for the second time again it throws up this error.

What could be the problem? Can anyone please let me know. Its really really urgent.

Thanks,

Prashant.

[Former Member · Accepted solution]

Please check ST22 and SM21 and see for any leads.

[edwin_harpino]

hi Prashant,

try check in RSRT, after choose your query, click 'properties' and set cache mode to 'main memory cache without swapping'.

also check oss note 656060-OLAP: Cache main memory displacement not functioning.

hope this helps.

Symptom

Although one of the following two cache modes

Main Memory Cache Without Swapping (mode 1)

Main Memory Cache With Swapping (mode 2)

is set for a query, long runtimes occur when you execute the query. The statistics (table RSDDSTAT) display the database times.

If there is a heavy system load, the following message can also appear: RS_EXCEPTION000: No left space in shared memory.

Other terms

Cache, performance, displacement, shared buffer

Reason and Prerequisites

This problem occurs because the shared memory is insufficiently dimensioned.

<b>Solution</b>

Increase the amount of shared memory. The size of the shared memory should be at least 200 MB. You can refer to transaction RSRCACHE for the amount of memory reserved by the main memory cache (RSRCACHE -> Main Memory: Shared Memory/Buffer Reserved).

The corresponding settings are (at least):

rsdb/esm/buffersize_kb = 200000

and, as a precaution, also

rsdb/esm/max_objects = 10000.

Alternatively, for queries with large resulting quantities, you can convert the Cache Mode in transaction RSRT1 to

Cluster/Flat File Cache for Each Application Server (mode 3)

Cluster/Flat File Cache Across Each Application Server (mode 4)