"siaj" wrote:

>
> Hello,
> I am getting an error with Reporting Sercvices 2000 when I run my report
> which typically takes 30 mts in Query analyzer which pulls 5393723 rows. I
> have tried with the combination of MemoryLimit of 0 and MaximumMemoryLimit of
> 80 and also combination of MemoryLimit of 100 and MaximumMemoryLimit of 120
> "Timeout expired : the timeout period elapsed prior to completion of the
> operation or the server is not responding". I have set the Reporting Srvices
> To never timeout.
>
> I get this error usually after 38 mts.
> My SQL Server has 6 GB RAM on it.
> The event log has message :
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
> error has occurred during report processing. --->
> System.OutOfMemoryException: Exception of type
>
>
> Wondering if somebody has seen a similar situation and has a workaround for
> the same.
>
> Thanks in advance,