May 10, 2011 at 10:04 am
We have a report with more than 30 parameters that used to run well on SQL 2008. For the past few weeks the report has failed to run from any browser. The report returns resultset in Visual studio.
For some reason i get out of memory error exception when i run the report from a browser. How can I tackle this problem. I have number of parameters with multiple select values. Couple of parameters have a large string value. I cannot eliminate any of the parameters. I have to use all the parameters. I even tried setting up a subscription, it fails on the subscription page as well. I desperately need to fix this report as soon as possible. Any kinda of help or suggestion would be greatly appreciated.
Thanks in Advance
Codezilla
May 10, 2011 at 10:17 am
Stop and restart Reporting Services, see if that helps
May 10, 2011 at 11:47 am
nope that didnt help either. Thanks for your suggestion.
May 10, 2011 at 12:22 pm
Try shutting down ad restarting the server, if not you may need more memory for the server
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply