Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
can anyone help me out what exactly the problemIt looks like you call stack exceeds maximum allowable level. It means that you run a stored procedure that executes another stored procedure that executes yet another... and so on.
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.
