Solved

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

Posted on 2012-04-05
3
4,359 Views
Last Modified: 2012-04-16
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>
0
Comment
Question by:TheAnvilGroup
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
sqlservr earned 500 total points
ID: 37810222
this a common issue,
shrink the log file and rerun the report ,it works
0
 
LVL 1

Author Comment

by:TheAnvilGroup
ID: 37826612
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
 
LVL 1

Author Closing Comment

by:TheAnvilGroup
ID: 37850606
This solution may work in other scenerios but not in mine.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

740 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