SQL Reporting Services Error- Maximum request length exceeded
September 16 |
By Ryan McBee
When trying to deploy a large Dynamics GP report to your SSRS server or creating a subscription for one of your canned GP SSRS reports, you may run into an error like this:
Error 2 There was an exception running the extensions specified in the config file. —> Maximum request length exceeded.
You could, quite honestly, run into this error in a lot of situations involving a web app, but we’re talking specifically about SSRS in this post. The basic problem here, is that your posting an amount of data to a web app larger than it is configured to accept. Hence, it is throwing an error.
It’s an easy fix though. You’ve got to adjust the web.config for the web app, which in the case of reporting server, is usually somewhere like this:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer
Find the web.config file for your reporting services instance, open it up, and track down the line that looks something like this
executionTimeout = “9000” />
Now just add a max request length attribute in there to fix the problem, adjust your size as needed. This is 5meg.
executionTimeout = “9000” maxRequestLength=”500000″ />
And now you’ll need to restart IIS. start->run->”iisreset”