Solved

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

Posted on 2012-04-05
3
4,080 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
encyps queries mssql 15 27
Join vs where 2 11
Stored Procedure 2 10
SQL Query 2 0
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now