Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 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