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
Post a Comment