Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2012-04-05
3
Medium Priority
?
4,812 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
[X]
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
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Ramesh Babu Vavilla earned 1000 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

722 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