Maximum Request Length Exceeded Help!

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.

max_errors in bcp

Can any one help on this ?
I have set the -m parameter for bcp for importing but its
not working.
C:\>bcp TestDB.dbo.TestTable in E:\DataFile.txt -w -m1000
-eE:\Error.txt -SServerName -Usa -P
ThanksWhat exactly is the problem? Couyld you be more specific?
Tengiz Khartishvili
SQL Server Storage Engine
This posting is provided "as is" with no warranties and confers no rights.
"Manoj" <manoj_raheja@.hotmail.com> wrote in message
news:11a5401c3f544$0570b6c0$a401280a@.phx
.gbl...
> Can any one help on this ?
> I have set the -m parameter for bcp for importing but its
> not working.
> C:\>bcp TestDB.dbo.TestTable in E:\DataFile.txt -w -m1000
> -eE:\Error.txt -SServerName -Usa -P
>
> Thanks
>

Max with Datepart

I am wanting to set any given @.Date parameter to the most current recorded Monday in a table (tblMarketPricing). Would this work:

@.Date = Max(Datepart(dw,MktDate) IN 2

I am unsure if you can use Max with the Datepart function.

***If this is not allowed, can anyone suggest anything different that I might try?

To get what you are asking for you need:

Select @.date = Max(MktDate) from tblMarketPricing where DatePart(dw, MktDate) = 2

assuming that 2 corresponds to Monday on your system.

You could consider using the DateName() function in place of DatePart().

Since it will otherwise be forthcoming, I will suggest that a Calendar table could also be used to provide these sorts of answers.

|||That worked! Thank you.