0

I'm working on SSRS report. It works fine when I run it from Report Builder.

Now, when I run the same report from my site, which uses Report viewer to show the report, timeout issue occurs. So I have observed that it times out after 90 seconds. Can anyone please help me what should I do in this case?

- I've set Do not timeout report from Site Settings

enter image description here

- I've also set Time in Report Dataset properties.

enter image description here

  • I also tried, Processing Options.

enter image description here

BIDeveloper
  • 2,628
  • 4
  • 36
  • 51
Pedram
  • 6,256
  • 10
  • 65
  • 87
  • It's just a mere guess, but... is the connection between your site and the report server set up right? – Andrea May 11 '16 at 12:52
  • Chances are the report builder is caching data locally, making it seem like it is working there. Do you get the same timeout, or long running query, when you refresh the data in report builder? – R. Richards May 11 '16 at 13:20
  • I'm getting same timeout – Pedram May 11 '16 at 14:13

2 Answers2

1

I found the solution, it was issue with ajaxToolkit:ToolkitScriptManager

I needed to add AsyncPostBackTimeout="56000" to ajaxToolkit:ToolkitScriptManager.

Before

<ajaxToolkit:ToolkitScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True"/>

After

<ajaxToolkit:ToolkitScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True" AsyncPostBackTimeout="56000"/>

Now it works fine.

Pedram
  • 6,256
  • 10
  • 65
  • 87
0

For starters, in your data set properties, I would set the time out property for all data sets to 0. This should mean that they do not time out. This may not be a practical decision for all reports all the time but if you're having timeout issues, that's a good place to start.

Do you just have one dataset? And if so, when you run the query in SQL Server Management Studio, how long does it take to execute?

Christopher Brown
  • 2,170
  • 1
  • 13
  • 19
  • thanks for answer. It was having issue `ajaxToolkit:ToolkitScriptManager`. I have answered to my own question so that it can help to others. btw from SSMS it was taking around 3 mins to execute and I had two dataset on same report. But second one was taking less time than first one. again thanks for answer. :) – Pedram May 19 '16 at 04:31