I have a report that has 14 user supplied parameters. When I added a 15th parameter and deployed the report, I get an error of Maximum Request Length Exceeded when I try to set up a subscription to the report. All of the subscriptions on the report are failing now and users are getting rather upset. Please help! How do I get rid of the Maximum Request Length Exceeded error? Thanks!

i'm not entirely sure, but shortening your parameter names may help. ie: CustomerLocation to 'Loc'

Redmanmc wrote: I have a report that has 14 user supplied parameters. When I added a 15th parameter and deployed the report, I get an error of Maximum Request Length Exceeded when I try to set up a subscription to the report. All of the subscriptions on the report are failing now and users are getting rather upset. Please help! How do I get rid of the Maximum Request Length Exceeded error? Thanks! did you ever find a fix for this problem? i seemed to have stumbled upon it myself. thanks

Unfortunently I have not found a solution to the problem yet. I tried reducing the length of the variable names but it did not fix the problem. If anyone out there has a fix please yell out!

good news.. found a fix for this. it's actually the same fix for file uploads that exceed the default 4mb set by IIS. however, the change needs to made to the report manager web.config file and not the report server web.config file. that's why it didn't work for me the first time. here is an article that talks about it http://support.softartisans.com/kbview_825.aspx if you have kept the default installation directory, the file you edit is: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Web.config Just add the maxRequestLength property here and set a size appropriate to you. Not to large to discourage DoS attacks. The example below is 10mb <httpRuntime executionTimeout="9000" maxRequestLength="10240"/> hope it helps.

Hello, I am receiving this error on one of our reporting web servers that has reporting services installed and adding the maxRequestLength parameter to allow up to 10mb did not solve the Maximum Request Length error. Does anyone have any other solutions to this, some sort of configuration setting fix with the Reporting Services install maybe?

Hi Guys,I came across the same error when trying to alter one of the Subscriptions which was ona Shared Schedulein Reporting Services.Deleted the Subscription & tried to recreate it so it could use a Custom Schedule & write the file to Windows Filesharebut it gave me the same error. However, was thenable to create the subscription from the Management Studio after connecting to Reporting Services.Try Browsing thru to that Report under Home--> Reports Folder--> Report Name--> Subscriptions.You should be able to create/modify/delete subscriptions from here i.e even set schedules,parameters etc.

so let's say we have a report with one parameter called "empName" - free text form: How many names could this parameter box contain? are we sayig 1600 characters worth of names? Is the limit per character count (a+b+c = 3 chars)? or is there a KB size limit on passing parameters?

I tried to limit the data (reduce number of datarows) on each parameter and it solves our issue. You might want to try to limit/reduce the data retured on each parameters if possible.