Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Services Errors SQLServerAgent exceeded the allowed timeout Expand / Collapse
Author
Message
Posted Friday, February 24, 2012 5:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 2:33 AM
Points: 91, Visits: 540
Hey There

Coming across the below error in our reporting services log file can anyone tell me what is causing this been googling for the last few days with no luck...


An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: SQLServerAgent exceeded the allowed timeout for creating the shared job list. The Jobs cannot be enumerated.

We are running SQL Server 2008 R2 SP1 x64...

these errors are also beein log in the log file

ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;

At a loss at to what is causing this your help would be much appreciated

Thanks
Post #1257338
Posted Monday, February 27, 2012 2:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 2:33 AM
Points: 91, Visits: 540
No one?.... damn
Post #1258076
Posted Tuesday, November 19, 2013 12:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 6:27 PM
Points: 24, Visits: 113
I'm experiencing the same problem on some of my SSRS reports, and it appears to be intermittent.

We have several hundred report subscriptions, the SQL Agent Jobs report success, but I get messages in the SSRS log to this effect:

[color=#000000]11/17/2013-02:15:31:: Error processing event 'TimedSubscription', data = fdce1441-883d-409c-8dd6-401ed2c9f331, error = Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: SQLServerAgent exceeded the allowed timeout for creating the shared job list. The Jobs cannot be enumerated.[/color]

I've learned that the enumeration is handled by xp_sqlagent_enum_jobs procedure, which is undocumented. However, I can run the following and I get results very quickly (sub-second):

exec master.dbo.xp_sqlagent_enum_jobs 1, ''

The 2 reports that have this issue have been running fine, and nothing has changed for these reports or the servers/etc involved in months. Also, scheduled reports before and after these ran fine. It seems like something else is causing these to hang. Both reports with the issue run outside of business hours when db usage is very low.

Any thoughts? Running on Windows 2008 R2, SQL Server 2012, VMWare esxi 5
Post #1515718
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse