Query executes in RSRT but not in BEx Analyzer

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.