Report doesn't run from Reporting Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Report doesn't run from Reporting Server

Report doesn't run from Reporting Server

Rate Topic

Display Mode

Topic Options

Author

Message

tt-615680

Posted Wednesday, March 06, 2013 8:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 12, 2013 7:42 AM
Points: 225, Visits: 809

Dear All,

I'm trying to run a Report on the Reporting Server but for some reason the reports executes but hangs. In Visual Studio, when the Report is run from the Dataset (right click on the Dataset-> Dataset Properties-> Query Designer-> execute the report) it works fine, but when I righ click on the actual report then select run the Report executs but it just hangs. I want to know what the cause of it could be please?

Thank you in advance!

Post #1427448

Gazareth

Posted Thursday, March 07, 2013 3:16 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

Typically that would indicate it's taking time to create and/or render the report. Are you getting an error or just the spinning wheel?
Leave it running until it times out & check the executionlog view in ReportServer database - it has fields TimeDataRetrieval, TimeProcessing, TimeRendering which can help you work out what's taking the time.

Post #1427869

peterzeke

Posted Friday, March 08, 2013 6:28 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 285, Visits: 1,206

Sometimes when a report seems to run "forever" or timeout, the problem stems from either having an underlying query that is written as "Select * From...." -- Seems like SSRS report manager gets tripped up by the "*" once in awhile, especially if the underlying fields have changed.

Another issue that sometimes causes problems is parameter sniffing. If your query uses a stored procedure where reporting services passes a parameter value, you may be running into parameter sniffing. Plenty of articles on SSC about easily overcoming this type of problem.

Just my two cents.

--Pete

Post #1428551

tt-615680

Posted Friday, March 08, 2013 6:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 12, 2013 7:42 AM
Points: 225, Visits: 809

Thank you for your reply! Yes, the Reports runs but hungs for a very long time but eventually gets the data but my question is why would the Stored Procedure run quicker than the when running the Rport on the Server.

Post #1428553

peterzeke

Posted Friday, March 08, 2013 6:52 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 285, Visits: 1,206

I wish I could tell you exactly why a report might be so much slower in report manager vs. BIDS, especially when the report is referencing a parameterized stored proc.

Nonetheless, based on my own experiences, when a report does run slow in report manager vs BIDS, I usually discover a parameter sniffing problem.

So, here are a couple of links to articles about overcoming parameter sniffing:

http://elegantcode.com/2008/05/17/sql-parameter-sniffing-and-what-to-do-about-it/

http://www.sqlservercentral.com/blogs/practicalsqldba/2012/06/25/sql-server-parameter-sniffing/

--Pete

Post #1428561

« Prev Topic | Next Topic »

Permissions