SQL Server Reporting Service Reports Error connection failure, timeout or low disk condition within the database

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. Low disk condition will not be the fault as there's plent of free space, connection failure is unlikely as it's on the same server as the database which leaves a timeout. Looking at the error task it runs at 2:01:00 and errors at 2:01:37 and about 12 tasks are also running from 02:00:00 to 02:01:30.

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.;

Here's an extract from my rsreportserver.config
      <Add Key="SecureConnectionLevel" Value="0"/>
      <Add Key="CleanupCycleMinutes" Value="10"/>
      <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
      <Add Key="MaxActiveReqForOneUser" Value="80"/>
      <Add Key="DatabaseQueryTimeout" Value="240"/>
      <Add Key="RunningRequestsScavengerCycle" Value="180"/>
      <Add Key="RunningRequestsDbCycle" Value="180"/>
      <Add Key="RunningRequestsAge" Value="90"/>
      <Add Key="MaxScheduleWait" Value="60"/>
      <Add Key="DisplayErrorLink" Value="True"/>
      <Add Key="WebServiceUseFileShareStorage" Value="False"/>

      <Service>
            <IsSchedulingService>True</IsSchedulingService>
            <IsNotificationService>True</IsNotificationService>
            <IsEventService>True</IsEventService>
            <PollingInterval>10</PollingInterval>
            <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
            <MemorySafetyMargin>80</MemorySafetyMargin>
            <MemoryThreshold>90</MemoryThreshold>
            <RecycleTime>1440</RecycleTime>
            <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
            <MaxQueueThreads>0</MaxQueueThreads>
LVL 1
TheAnvilGroupAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ramesh Babu VavillaCommented:
this a common issue,
shrink the log file and rerun the report ,it works
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TheAnvilGroupAuthor Commented:
This comment about shrinking database may actually result in a degradation of performance more reports are now failing I had 5 errors on Monday morning.

Back to the original issue the reports ran between 02:01 and 02:11 and the error message is as below:
library!WindowsService_6!111b4!04/09/2012-02:05:31:: e 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., ;
library!WindowsService_6!10ef8!04/09/2012-02:05:31:: i INFO: Schedule 60265961-d52a-4def-b38d-795ecb8ca6de executed at 04/09/2012 02:05:31.
schedule!WindowsService_6!10ef8!04/09/2012-02:05:31:: Creating Time based subscription notification for subscription: d1623912-c4f7-4741-903b-7028405b5d3a
schedule!WindowsService_6!111b4!04/09/2012-02:05:31:: Error processing event 'TimedSubscription', data = aa6246fe-0866-4d52-97f2-7527fe229b92, 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.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteReader>b__1()
   at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e)
   at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m)
   at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.SqlAgentScheduler.GetNextRunTime(Guid id)
   at Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRunTime(Task t)
   at Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunTime(Task t)
   at Microsoft.ReportingServices.Library.SchedulingDBInterface.GetTask(Guid id)
   at Microsoft.ReportingServices.Library.ScheduleFireEventHandlerBase.StartSchedule(ICatalogQuery catalogQuery, String eventData, ArrayList& reports)
   at Microsoft.ReportingServices.Library.ScheduleFireEventHandlerBase.HandleScheduleEvent(ICatalogQuery catalogQuery, String eventData, PerformEventActions handleFunction)
   at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.HandleEvent(ICatalogQuery catalogQuery, String eventType, String eventData)
   at Microsoft.ReportingServices.Library.EventQueueWorker.ProcessSingleEvent(IEventHandler eventHandler, EventQueueItem item)
0
TheAnvilGroupAuthor Commented:
This solution may work in other scenerios but not in mine.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.