ReportExecution2005 timing out while rendering S!L Server 2012 reports.

Good morning experts,

Background: this system renders PDF reports using proxy endpoint ReportExecution2005 against SQLServer 2012,

throwing error:

The operation has timed out

Inner Exception: System.Net.WebException: The operation has timed out at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

By looking at the MSDN Library it is my uinderstanding that to render SQL Server 2014  reports one has to use https://Server/ReportServer/ReportExecution2005.asmx. If my understanding is incorrect what methods from https://server/reportserver/reportservice2010.asmx should the program use to render a report as a  pdf file? the msdn library refers to SQL Server 2014 what about 2012?.
Note: found "the ReportService2010 Web service enables developers to programmatically MANAGE  objects on a report server that is configured for either SharePoint integrated mode or native mode. " 

Your help is greatly appreciated it, this is urgent.

Thanks and best regards,
Nancy
NancymdAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bcnagelCommented:
Hi Nancy.

You are right about using the ReportExecution2005 namespace to render reports, even in SSRS 2014. I've always found that confusing.

Can you give us an idea as to what changed prior to this error cropping up? You referenced both SSRS 2012 and 2014 in your question--which are you using? Have you upgraded from 2012 to 2014 and are seeing the error after that upgrade?

If nothing has changed, can you try to render as *small* a PDF as possible? We sometimes see timeout errors when SSRS is chewing through an enormous dataset. If you can use parameters to cut down the size of your request, perhaps you won't see the timeout?
NancymdAuthor Commented:
Thanks bcnagel,

I did an upgrade  and a migration to Win 2012 server with SQLServer 2012. Yesterday we discovered a report with a huge dataset hung and prevented the rest of the reports to run. Which brings me to ask what do SSRS provides to handle huge dataset is it not capable of handling a big dataset?  

Nancy
bcnagelCommented:
I understand, Nancy: at least now you know why you were seeing the operation time out.

When we have seen timeouts in SSRS, I can think of four things we've had to deal with:

The datasource is timing out: it always makes sense to verify that this is not a SQL configuration problem, for example.
Query tuning: sometimes a bit of attention to SQL syntax (if that's your datasource) is all that's needed.
Look into SSRS's memory management options (as here: https://msdn.microsoft.com/en-us/library/ms159206.aspx), to make sure that the settings work for your environment
The DatabaseQueryTimeout setting in the RSReportServer configuration file (more here: https://msdn.microsoft.com/en-us/library/ms157273.aspx) allows you to buy more time to wait on long queries.

Let me know if any of those suggestions are helpful. Good luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NancymdAuthor Commented:
I looked at the timeout setting on the reports and changed it from 0 to 9000.  VS returns "success deploying reports"  but it is not copying the  reports to the server. Has any expert experienced this before?  Is there a way to change this setting on the server report manager? I have not found a way yet.

The DatabaseQueryTimeout      on the file RsReportServer.config  on the server is set to 120. According to MSDN "DatabaseQueryTimeout Specifies the number of seconds after which a connection to the report server database times out. This value is passed to the System.Data.SQLClient.SQLCommand.CommandTimeout property. Valid values range from 0 to 2147483647. The default is 120. A value of 0 specifies an unlimited wait time and therefore is not recommended.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.