Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

server not responding due to a long running script and SSRS

Posted on 2015-01-15
6
Medium Priority
?
1,056 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Google currently has a new report that is in beta and coming soon to Webmaster Tool accounts. This Micro Tutorial will highlight new features for Google Webmaster Tools.
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 +…

824 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