Solved

server not responding due to a long running script and SSRS

Posted on 2015-01-15
6
687 Views
Last Modified: 2015-01-24
When viewing a report in report manager clicking the next page arrow causes IE11 to hang; clicking the browser window displays a message that says "X is not responding due to a long running script " where x is my server name.

This report runs fine in Chrome and also against a local instance of reporting services so there's something about my server configuration that's stopping it running

The server is windows server 2008 and the SSRS version is sql server 2012 standard with SP2 applied
0
Comment
Question by:monserob
  • 3
  • 3
6 Comments
 
LVL 7

Expert Comment

by:DrAtomic
ID: 40550818
If the report runs fine in Chrome and times out in IE11 then the issue is with IE11 and not with your server configs. Had the issue been with your server configs then Chrome would have had the same issue. Most likely IE11 cuts off the request due to the report taking long to generate.
0
 

Author Comment

by:monserob
ID: 40550872
The report runs fine in IE11 against a local instance of reporting services. It's only two pages in total and takes less than a second to generate so it's not even a long-running report
0
 
LVL 7

Expert Comment

by:DrAtomic
ID: 40550878
Try running fiddler (free download at http://www.telerik.com/fiddler) whilst running the IE11 remotely then compare that against Chrome remotely.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:monserob
ID: 40551068
And what exactly am I comparing?
0
 
LVL 7

Expert Comment

by:DrAtomic
ID: 40553152
First establish that both Chrome and IE11 are receiving the same responses, then see where the errors in IE11 occur that are causing the timeout. This will give you a handle to further troubleshoot the issue, it might be a setting that is needed in IE11 for it to function correctly or Chrome might be using a different address to obtain the reports over IE11. Bottomline is you should be able to find out why Chrome is working just fine and IE11 is giving you issues.
0
 

Accepted Solution

by:
monserob earned 0 total points
ID: 40563914
In the end I changed the report so that everything is treated as one page in the browser i.e. the user does not have to click the next page :-)
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Several part series to implement Internet Explorer 11 Enterprise Mode
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now