Getting Server UnAvailable Error

Question

Getting Server UnAvailable Error

Jai Prakash

SSC Journeyman

Points: 99
More actions
October 3, 2005 at 12:11 am

#110994

Hope somebody else also would have come across this.
When the no of pages exceeding 500, while exporting to Excel I am getting Server Unavailable error. Is there any fix for this? I think SRS is using all available RAM while exporting. How to handle such situation?
Any idea will be highly appreciated.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47795 More actions · Answer 1

The best "fix" is re-analyse the purpose of the report and how the data is going to be used. I don't know of anyone in their right mind that would look at every page in a 500 page Excel report.

Also, if these are actual pages, you do realise that seperate pages will be individual sheets in the workbook??

--------------------
Colt 45 - the original point and click interface

Jai Prakash SSC Journeyman Points: 99 More actions · Answer 2

I agree with you. Most of the reports are fine, but for few reports, users need data for 4-5 months, due to which the no of pages increases. I have already suggested the users to apply some filter to reduce the no of rows in out. But they don't want to generate the report no of times.

philcart SSC-Forever Points: 47795 More actions · Answer 3

I'd be seriously considering talking to these users and working out what they're doing with 4-5 months worth of data in one report thats 500 pages long.

Is this an actual report, or are they re-processing or otherwise manipulating the data? Maybe explain that the company invested money in database servers so that they can do the data processing work instead. If this is the case, and they still want the "report" as-is then maybe DTS is the better tool for the job.

--------------------
Colt 45 - the original point and click interface

Syed Asim Rizvi Ten Centuries Points: 1162 More actions · Answer 4

I think Phill is right, but you can change memory size. By default RS uses maximum of 60% of available memory. You can change this setting (if you wants to) by changing value of

in RSReportServer.config file (resides in \MSSQL\Reporting Services\ReportServer folder).

This might help.

Jai Prakash SSC Journeyman Points: 99 More actions · Answer 5

I was not knowing that it can be configured in RSReportServer.Config. Thanks a lot for your info.