Exception of type system outofmemoryexception was thrown SSRS Reports through SSAS Cube


hi,

i have created cube in ssas 2008,

and called cube ssrs report add 20 fields in ssrs dataset

see,when preview report ,i got following error,

error:

an error has occurred during local report processing

an error has occurred during report processing

"exception of type system outofmemoryexception thrown ssrs reports"

can explain me please why occured step step?

hi samba ,

the issue occurs because computer not have sufficient memory complete requested operation .

this situation occur when 1 or more of following conditions true :
• a report large or complex .
• the overhead of other running processes high .
• the physical memory of computer small .

we can reduce memory consumption redesigning report queries in following ways:
• return less data in report queries.
• use better restriction on clause of report queries.
• move complex aggregations data source.

there similar issue , can refer following kb article:
http://support.microsoft.com/kb/909678/en-us

thanks,
alisa tang



SQL Server  >  SQL Server Reporting Services, Power View



Comments

Popular posts from this blog

Motherboard replacement

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

Remote Desktop App - Error 0x207 or 0x607