Error deploying large Report Model

SQL Server Reporting Services

Patdev


Hi ,

I am trying to deploy the report model which is more than 4 mb size. I am getting following error:

Error 2 There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

i changed the web.config on the server side:
as following:
<!--
<httpRuntime
executionTimeout = "600" [in Seconds][number]
maxRequestLength = "102400" [number]
requestLengthDiskThreshold = "80" [number]
useFullyQualifiedRedirectUrl = "false" [true|false]
minFreeThreads = "8" [number]
minLocalRequestFreeThreads = "4" [number]
appRequestQueueLimit = "5000" [number]
enableKernelOutputCache = "true" [true|false]
enableVersionHeader = "true" [true|false]
apartmentThreading = "false" [true|false]
requireRootedSaveAsPath = "true" [true|false]
enable = "true" [true|false]
sendCacheControlHeader = "true" [true|false]
shutdownTimeout = "90" [in Seconds][number]
delayNotificationTimeout = "5" [in Seconds][number]
waitChangeNotification = "0" [number]
maxWaitChangeNotification = "0" [number]
enableHeaderChecking = "true" [true|false]
/>
-->
<httpRuntime executionTimeout="600" maxRequestLength="102400" requestLengthDiskThreshold="80" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false" />

But still gets same error: what else i ahve to change.

Please help!!

Thanks




Top

Re: Error deploying large Report Model

BlackStallion


What is the size You want to go behind the maxRequestLength setting and increase it till you are able to deploy. http://msdn2.microsoft.com/en-us/library/e1f13641(VS.80).aspx speaks in detail about HTTPRuntimes






Top

Re: Error deploying large Report Model

Patdev

Hi,

the size of the model is about 6 mb the size i have in web.cofing for MaxRequestLength = '102400' ( i think it should be enough) and also changeed requestlimit in maching to '50147483647'

I also did IISRESET too after that!!

what else i have to do.






Top

Re: Error deploying large Report Model

Patdev

Hi,

I also want to know the location of web.confing if i am doing right!!

on my system i have web.config and web.config.comment. and there is only MaxRequestLenght in .comment file and i updated that to 102400!! also the execution time out to 1200:

the location is: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Thanks





Top

Re: Error deploying large Report Model

tmorgan_uk

Hi there,

Not sure if this will be of any help, or wether I've just mis-understood, but I found this post via search and have solved this exception.

However, in your post, where you quote the location (the .net2 framework dir), surely this isn't where the web.config was FWIW, I changed the web.config in the [SQL Server Directory]/[MSSQL RS Instance]/Reporting Services/ReportServer directory.

That seemed to do it for me. I only changed the MaxRequestLength. My model is 4mb.

-tom


Top