Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Sharepoint 2013/SSRS error long reports
Posted on 2014-03-11
We are upgrading our Sharepoint to 2013. I have several reports that take about 3minutes to run because of a slow ODBC connection used by a linked server.
They ran fine in Sharepoint 2007. They run fine in Visual Studio 2013. However they return this error after about 1.5 minutes.
Sys.WebForms.PageRequestMa
Some reports run fine, it is only the ones that take longer than 1.5 minutes. I have tried adjusting every timeout option I can find. I have tried adding a connection timeout to the dataset. I have updated the report processing options to not timeout. I have added this to the web config file.
<httpRuntime maxRequestLength="51200" requestValidationMode="2.0
No luck. Please help!!
They ran fine in Sharepoint 2007. They run fine in Visual Studio 2013. However they return this error after about 1.5 minutes.
Sys.WebForms.PageRequestMa
Some reports run fine, it is only the ones that take longer than 1.5 minutes. I have tried adjusting every timeout option I can find. I have tried adding a connection timeout to the dataset. I have updated the report processing options to not timeout. I have added this to the web config file.
<httpRuntime maxRequestLength="51200" requestValidationMode="2.0
No luck. Please help!!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
11 Comments
Have you considered re-designing the reports so that they actually run automatically in advance and it's only the presentation that happens on-demand?
That is not an option, we go live on Saturday.
I have figured out the reports run as subscriptions and email just fine. They just don't come up on the screen in the report viewer.
I have figured out the reports run as subscriptions and email just fine. They just don't come up on the screen in the report viewer.
How big are the reports? i.e. how much information to they move. Don't forget that there are limits to how much data SSRS can pivot and render. If you're viewing them on relatively small machines they may be just running out of space for rendering, and, in my experience, SSRS just "doesn't" - no warnings, nothing. Just a blank screen!
This is the error:
Sys.WebForms.PageRequestMa
We have a brand new VM with Windows Server 2012, it is only using 25% of the capacity while the report runs.
Sys.WebForms.PageRequestMa
We have a brand new VM with Windows Server 2012, it is only using 25% of the capacity while the report runs.
"We have a brand new VM with Windows Server 2012, it is only using 25% of the capacity while the report runs."
And, as you observe, reports run there and turned into (presumably) pdf files and emailed out work fine.
OTOH, reports running on workstations fail.
This points to a problem with the workstations. So far as I am aware, SSRS renders on the local machine. Therefore, if you are sending a lot of information to the SSRS rendering engine it can just fail, giving you nothing to look at! Personally, I managed to achieve that by sending about 30,000 rows to a tablix!
hth
Mike
And, as you observe, reports run there and turned into (presumably) pdf files and emailed out work fine.
OTOH, reports running on workstations fail.
This points to a problem with the workstations. So far as I am aware, SSRS renders on the local machine. Therefore, if you are sending a lot of information to the SSRS rendering engine it can just fail, giving you nothing to look at! Personally, I managed to achieve that by sending about 30,000 rows to a tablix!
hth
Mike
I have been testing on the server itself not on a workstation.
Are there any settings I can change to allow SSRS to render for a longer period?
I am pretty sure it is timing out. It always times out at 2 minutes.
Are there any settings I can change to allow SSRS to render for a longer period?
I am pretty sure it is timing out. It always times out at 2 minutes.
What's taking the time? Is it the query or the data transfer? Can you tell, maybe, by running a failing report's query on the database into a table and then re-running a version of the report with the report just doing a straight select from the new table?
If it's the transport then you're pretty much screwed unless you can speed it up or change the timeout in either SSRS or Sharepoint (I'd imagine that it would be a Sharepoint poblem, as SSRS was running them ok in 2007. If the query then look to ways of speeding it up.
Mike
If it's the transport then you're pretty much screwed unless you can speed it up or change the timeout in either SSRS or Sharepoint (I'd imagine that it would be a Sharepoint poblem, as SSRS was running them ok in 2007. If the query then look to ways of speeding it up.
Mike
This may help for SSRS timeouts:
http://technet.microsoft.com/en-us/library/ms155782.aspx
There are also some suggestions here (I'm not a Sharepoint developer, but some are relevant to this problem:
http://blogs.msdn.com/b/mariae/archive/2009/09/24/troubleshooting-timeout-errors-in-reporting-services.aspx
Good luck!
Mike
http://technet.microsoft.com/en-us/library/ms155782.aspx
There are also some suggestions here (I'm not a Sharepoint developer, but some are relevant to this problem:
http://blogs.msdn.com/b/mariae/archive/2009/09/24/troubleshooting-timeout-errors-in-reporting-services.aspx
Good luck!
Mike
Featured Post
Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 5 hours left to enroll
Earn Certification
MTA - Cloud Fundamentals - 98-369
$59.00$53.10
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.