Reporting Service Trouble Shooting #1–failed to deploy large RDL file.

From now on,  I will collect some interesting technical issues here. As you can see, I break down them into different buckets like SSRS, SSIS, SSAS, PowerBI, Powerpivot….

This thread starts the series on trouble shooting. (BTW, you will see “design tips” series too very soon.)

Well, this was an interesting issue because I never encountered it before even I have already SSRS or more than 7 or 8 years. Alright, let us talk about this issue.

Did you see this error before, see below screen shot?

Error

RS complains “Maximum Request Length Exceed” when you deploy reports to RS portal. Actually, I like this error, pretty concise and specific, which is much better than some errors with a general verbage.

My gut feeling for this error is something wrong in file size as it says “Request length exceeded”, so let’s check out the file size of this RDL file. It is 5.8 MB, well, a little bit bigger than normal files.

filesize

 

What the default maximum value for uploading/deploying RDL file? 4MB. yes, it is 4 MB. That’s why I got that error.

How to resolve it? Add an attribute in the file “Web.config”. Steps as below,

Browse to the RS installation folder(“C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\”, you should see this file “web.config”. Open it and add(Yes, “ADD”. It was not there) the attribute as below

maxRequestLength=”500000″ in the section of “httpRuntime”. (this size depends on you. 500000 here works well for my case.) It is Kilobyte.

Web

 

Now, someone would say you need to restart IIS to make sure this takes effect. Hum..really. It is right for SQL2000 and SQL2005 but it no longer be true after SQL2008(including SQL2008). My case, I am using SQL 2008 R2, it takes effect immediately after this change.

My friends, take care, have fun.

 

 

 

 

 

Advertisements

Published by

Derek Dai

focusing DB, Big Data and BI tech.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s