Error during memory operation

[Former Member]

Hi.

During query processing I get following error from database,

Component Microsoft OLE DB Provider for Analysis Services 2008R2:

Error during memory operation. Error Code = 0xC1030001, External Code = 0x00000008

It happend when I extend query filter from one month to whole year. SSAS Cube contains about 2,5 bil records.

How can I avoid this problem.

Please help.

I have 32GB RAM on server, win 2008 R2, MS SQL server 2008 R2, BO XI 3.1 FixPack 4.

Regards

MG

[Former Member]

In Task Monitor I watched process WebiRichClient.exe. Error occurs exactly when memory usage exceed 1,2 GB.

I tested it on the client with 2 GB RAM and on the server with 32 GB RAM.

The memory usage threshold on both machines seems the same.

Maybe it's usefull information...

Regards

MG

[denis_konovalov]

WebiRichClient is a 32bit Java process, it can't go higher that 2gb of memory. 32bit architecture limitation.

By changing Java properties for WebiRichClient you can probably bump Xmx parameter to 1536 on windows (do not think 2048 will work) , but the issue is - you have designed inefficient query.