none
SSRS 2008 An error occurred within the report server database

    Question

  • Unable to access report manager in ssrs22008R2 , which previously worked fine for about 2 weeks .

    Starting the RS generates a logfile with no errors as shown below

    ==========================starting RS logfile ======================

     

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
      <Locale>English (United States)</Locale>
      <TimeZone></TimeZone>
      <Path>D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__12_08_2010_15_10_40.log</Path>
      <SystemName>SSRSHPPNRS0010A</SystemName>
      <OSName>Microsoft Windows NT 6.1.7600</OSName>
      <OSVersion>6.1.7600</OSVersion>
      <ProcessID>5012</ProcessID>
      <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!1634!12/08/2010-15:10:40:: i INFO: CLR runtime is initialized.
    rshost!rshost!1634!12/08/2010-15:10:40:: i INFO: Derived memory configuration based on physical memory as 33554432 KB
    appdomainmanager!DefaultDomain!1098!12/08/2010-15:10:40:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing ConnectionType to '1'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing AuthenticationTypes to '4'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
    resourceutilities!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Reporting Services starting SKU: Enterprise
    configmanager!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Using report server external url http://SSRSHPPNRS0010A:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Using url root http://SSRSHPPNRS0010A:80/ReportServer.
    rshost!rshost!1734!12/08/2010-15:10:40:: i INFO: Configuring maxPhysicalCpu=8, minLogicalCpu=0
    rshost!rshost!1734!12/08/2010-15:10:40:: i INFO: Logical processor per physical processor 12
    rshost!rshost!1734!12/08/2010-15:10:40:: i INFO: Maximum logical CPU is 24
    configmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Using report server external url http://SSRSHPPNRS0010A:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Using url root http://SSRSHPPNRS0010A:80/ReportServer.
    appdomainmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Appdomain:2 WindowsService_0 started.
    resourceutilities!WindowsService_0!1734!12/08/2010-15:10:41:: i INFO: Reporting Services starting SKU: Enterprise
    library!WindowsService_0!1138!12/08/2010-15:10:41:: i INFO: Catalog SQL Server Edition = Enterprise
    crypto!WindowsService_0!1138!12/08/2010-15:10:41:: i INFO: Initializing crypto as user: PROD\svcentsqlcl
    crypto!WindowsService_0!1138!12/08/2010-15:10:41:: i INFO: Exporting public key
    crypto!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: Performing sku validation
    crypto!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: Importing existing encryption key
    appdomainmanager!DefaultDomain!1734!12/08/2010-15:10:42:: i INFO: The UserAccountControl value for the service account is 590336
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    appdomainmanager!DefaultDomain!1734!12/08/2010-15:10:42:: i INFO: The UserAccountControl value for the service account is 590336
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager.
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    resourceutilities!DefaultDomain!1734!12/08/2010-15:10:42:: i INFO: Maximum memory limit is 2097152Mb
    rshost!rshost!1734!12/08/2010-15:10:42:: i INFO: Derived memory configuration based on physical memory as 33554432 KB
    servicecontroller!DefaultDomain!17b0!12/08/2010-15:10:42:: i INFO: Total Physical memory: 34359738368
    rpcserver!DefaultDomain!1308!12/08/2010-15:10:42:: i INFO: Process monitoring started.
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_0!7b0!12/08/2010-15:10:42:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
    dbpolling!WindowsService_0!115c!12/08/2010-15:10:42:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
    dbpolling!WindowsService_0!360!12/08/2010-15:10:42:: i INFO: PollingMaintenance: Polling started
    resourceutilities!WindowsService_0!360!12/08/2010-15:10:42:: i INFO: Maximum memory limit is 2097152Mb
    rpcserver!DefaultDomain!1138!12/08/2010-15:10:42:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!1138!12/08/2010-15:10:42:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER'
    appdomainmanager!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: Appdomain:2 WindowsService_0 initialized.
    library!DefaultDomain!abc!12/08/2010-15:10:43:: i INFO: Catalog SQL Server Edition = Enterprise

    =================================================end ===========================

     

    When I try to access the report manager then I get this error (An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help

    Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    )

    ==================================the log file looks like this =================================================

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
      <Locale>English (United States)</Locale>
      <TimeZone></TimeZone>
      <Path>D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__12_08_2010_15_10_40.log</Path>
      <SystemName>SSRSHPPNRS0010A</SystemName>
      <OSName>Microsoft Windows NT 6.1.7600</OSName>
      <OSVersion>6.1.7600</OSVersion>
      <ProcessID>5012</ProcessID>
      <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!1634!12/08/2010-15:10:40:: i INFO: CLR runtime is initialized.
    rshost!rshost!1634!12/08/2010-15:10:40:: i INFO: Derived memory configuration based on physical memory as 33554432 KB
    appdomainmanager!DefaultDomain!1098!12/08/2010-15:10:40:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing ConnectionType to '1'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing AuthenticationTypes to '4'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
    library!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
    resourceutilities!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Reporting Services starting SKU: Enterprise
    configmanager!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Using report server external url http://SSRSHPPNRS0010A:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:40:: i INFO: Using url root http://SSRSHPPNRS0010A:80/ReportServer.
    rshost!rshost!1734!12/08/2010-15:10:40:: i INFO: Configuring maxPhysicalCpu=8, minLogicalCpu=0
    rshost!rshost!1734!12/08/2010-15:10:40:: i INFO: Logical processor per physical processor 12
    rshost!rshost!1734!12/08/2010-15:10:40:: i INFO: Maximum logical CPU is 24
    configmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Using report server external url http://SSRSHPPNRS0010A:80/ReportServer.
    configmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Using url root http://SSRSHPPNRS0010A:80/ReportServer.
    appdomainmanager!DefaultDomain!1734!12/08/2010-15:10:41:: i INFO: Appdomain:2 WindowsService_0 started.
    resourceutilities!WindowsService_0!1734!12/08/2010-15:10:41:: i INFO: Reporting Services starting SKU: Enterprise
    library!WindowsService_0!1138!12/08/2010-15:10:41:: i INFO: Catalog SQL Server Edition = Enterprise
    crypto!WindowsService_0!1138!12/08/2010-15:10:41:: i INFO: Initializing crypto as user: PROD\svcentsqlcl
    crypto!WindowsService_0!1138!12/08/2010-15:10:41:: i INFO: Exporting public key
    crypto!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: Performing sku validation
    crypto!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: Importing existing encryption key
    appdomainmanager!DefaultDomain!1734!12/08/2010-15:10:42:: i INFO: The UserAccountControl value for the service account is 590336
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    appdomainmanager!DefaultDomain!1734!12/08/2010-15:10:42:: i INFO: The UserAccountControl value for the service account is 590336
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager.
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!17b0!12/08/2010-15:10:42:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    resourceutilities!DefaultDomain!1734!12/08/2010-15:10:42:: i INFO: Maximum memory limit is 2097152Mb
    rshost!rshost!1734!12/08/2010-15:10:42:: i INFO: Derived memory configuration based on physical memory as 33554432 KB
    servicecontroller!DefaultDomain!17b0!12/08/2010-15:10:42:: i INFO: Total Physical memory: 34359738368
    rpcserver!DefaultDomain!1308!12/08/2010-15:10:42:: i INFO: Process monitoring started.
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_0!7b0!12/08/2010-15:10:42:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
    dbpolling!WindowsService_0!115c!12/08/2010-15:10:42:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
    dbpolling!WindowsService_0!360!12/08/2010-15:10:42:: i INFO: PollingMaintenance: Polling started
    resourceutilities!WindowsService_0!360!12/08/2010-15:10:42:: i INFO: Maximum memory limit is 2097152Mb
    rpcserver!DefaultDomain!1138!12/08/2010-15:10:42:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!1138!12/08/2010-15:10:42:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER'
    appdomainmanager!WindowsService_0!1138!12/08/2010-15:10:42:: i INFO: Appdomain:2 WindowsService_0 initialized.
    library!DefaultDomain!abc!12/08/2010-15:10:43:: i INFO: Catalog SQL Server Edition = Enterprise
    appdomainmanager!DefaultDomain!a0c!12/08/2010-15:14:37:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129362948778417239 started.
    appdomainmanager!ReportManager_0-1!a0c!12/08/2010-15:14:38:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
    appdomainmanager!DefaultDomain!a0c!12/08/2010-15:14:38:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129362948778417239 initialized (#1).
    appdomainmanager!DefaultDomain!14e4!12/08/2010-15:14:40:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129362948802129281 started.
    appdomainmanager!ReportServer_0-2!14e4!12/08/2010-15:14:40:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!14e4!12/08/2010-15:14:40:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129362948802129281 initialized (#1).
    webserver!ReportServer_0-2!14e4!12/08/2010-15:14:43:: i INFO: Reporting Web Server started
    resourceutilities!ReportServer_0-2!14e4!12/08/2010-15:14:43:: i INFO: Reporting Services starting SKU: Enterprise
    resourceutilities!ReportServer_0-2!14e4!12/08/2010-15:14:43:: i INFO: Maximum memory limit is 2097152Mb
    library!ReportServer_0-2!1084!12/08/2010-15:14:45:: Call to GetPermissionsAction(/).
    library!ReportServer_0-2!1084!12/08/2010-15:14:45:: i INFO: Catalog SQL Server Edition = Enterprise
    crypto!ReportServer_0-2!1084!12/08/2010-15:14:45:: i INFO: Initializing crypto as user: PROD\svcentsqlcl
    crypto!ReportServer_0-2!1084!12/08/2010-15:14:45:: i INFO: Exporting public key
    crypto!ReportServer_0-2!1084!12/08/2010-15:14:45:: i INFO: Performing sku validation
    crypto!ReportServer_0-2!1084!12/08/2010-15:14:45:: i INFO: Importing existing encryption key
    library!ReportServer_0-2!1640!12/08/2010-15:14:45:: Call to GetPropertiesAction(/, PathBased).
    library!WindowsService_0!954!12/08/2010-15:15:05:: i INFO: Schedule 2f179fb5-8153-4124-9a13-a33935d3a1ce executed at 12/08/2010 15:15:05.
    library!WindowsService_0!3c4!12/08/2010-15:15:05:: i INFO: Schedule 91618b98-3e2f-4c03-a4d1-12e76eaba204 executed at 12/08/2010 15:15:05.
    schedule!WindowsService_0!954!12/08/2010-15:15:05:: Updating report execution snapshot for report /eCertified/IntelliCache_Dashboard/System Read Write Ratio
    schedule!WindowsService_0!3c4!12/08/2010-15:15:05:: Updating report execution snapshot for report /eCertified/IntelliCache_Dashboard/Top Shoppers Score Card
    library!WindowsService_0!954!12/08/2010-15:15:05:: Call to UpdateExecutionSnapshotAction().
    library!WindowsService_0!3c4!12/08/2010-15:15:05:: Call to UpdateExecutionSnapshotAction().
    library!WindowsService_0!3c4!12/08/2010-15:15:06:: i INFO: Initializing EnableIntegratedSecurity to 'True'  as specified in Server system properties.
    library!WindowsService_0!954!12/08/2010-15:15:06:: i INFO: Initializing EnableIntegratedSecurity to 'True'  as specified in Server system properties.
    library!WindowsService_0!3c4!12/08/2010-15:15:06:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
    library!WindowsService_0!954!12/08/2010-15:15:06:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
    library!WindowsService_0!954!12/08/2010-15:15:06:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
    library!WindowsService_0!3c4!12/08/2010-15:15:06:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
    processing!WindowsService_0!3c4!12/08/2010-15:15:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DashboardDataSource'. ---> System.Data.SqlClient.SqlException: Invalid object name 'eCertifiedControls.dbo.Carrier_Hit_Rate_Hourly_Cache'.
       at System.Data.SqlClient.SqlConnection.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.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)
       --- End of inner exception stack trace ---;
    processing!WindowsService_0!3c4!12/08/2010-15:15:08:: e ERROR: An exception has occurred in data set 'DashboardDataSource'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DashboardDataSource'. ---> System.Data.SqlClient.SqlException: Invalid object name 'eCertifiedControls.dbo.Carrier_Hit_Rate_Hourly_Cache'.
    processing!WindowsService_0!3c4!12/08/2010-15:15:08:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!WindowsService_0!3c4!12/08/2010-15:15:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DashboardDataSource'. ---> System.Data.SqlClient.SqlException: Invalid object name 'eCertifiedControls.dbo.Carrier_Hit_Rate_Hourly_Cache'.
       --- End of inner exception stack trace ---;
    processing!WindowsService_0!3c4!12/08/2010-15:15:08:: w WARN: Data source 'eCertifiedControls': Report processing has been aborted.
    processing!WindowsService_0!3c4!12/08/2010-15:15:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DashboardDataSource'. ---> System.Data.SqlClient.SqlException: Invalid object name 'eCertifiedControls.dbo.Carrier_Hit_Rate_Hourly_Cache'.
       --- End of inner exception stack trace ---;
    library!WindowsService_0!3c4!12/08/2010-15:15:08:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
    library!WindowsService_0!3c4!12/08/2010-15:15:08:: e ERROR: Schedule 91618b98-3e2f-4c03-a4d1-12e76eaba204 failed. Error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DashboardDataSource'. ---> System.Data.SqlClient.SqlException: Invalid object name 'eCertifiedControls.dbo.Carrier_Hit_Rate_Hourly_Cache'.
    library!WindowsService_0!954!12/08/2010-15:15:08:: i INFO: Initializing SnapshotCompression to 'SQL'  as specified in Server system properties.
    library!WindowsService_0!954!12/08/2010-15:15:08:: i INFO: Initializing ChunkSegmentSize to default value of '32320' Bytes because it was not specified in Server system properties.
    library!WindowsService_0!954!12/08/2010-15:15:09:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
    library!WindowsService_0!954!12/08/2010-15:15:09:: i INFO: Schedule 2f179fb5-8153-4124-9a13-a33935d3a1ce execution completed at 12/08/2010 15:15:09.
    schedule!WindowsService_0!954!12/08/2010-15:15:09:: Creating notifications for report execution snapshot update event for report 1c607d2b-1444-4383-9805-051cb1ba3476
    library!ReportServer_0-2!1640!12/08/2010-15:16:51:: 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!ReportServer_0-2!1640!12/08/2010-15:16:51:: e 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: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    ui!ReportManager_0-1!a0c!12/08/2010-15:16:51:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> 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: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetProperties(String Item, Property[] Properties, Property[]& Values)
       at Microsoft.ReportingServices.WebServer.ReportingService2010.GetProperties(String ItemPath, Property[] Properties, Property[]& Values)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.GetProperties(String ItemPath, Property[] Properties)
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass13.<GetProperties>b__12()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()
       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.GetProperties(String itemPath, Property[] properties)
       at Microsoft.ReportingServices.UI.ReportingWebControl.GetItemProperties(String itemPath, String[] properties)
       at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)
       at System.EventHandler.Invoke(Object sender, EventArgs e)
       at System.Web.UI.Control.OnInit(EventArgs e)
       at System.Web.UI.Page.OnInit(EventArgs e)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    library!ReportServer_0-2!abc!12/08/2010-15:16:51:: Call to GetSystemPermissionsAction().
    ui!ReportManager_0-1!a0c!12/08/2010-15:16:51:: e ERROR: HTTP status code --> 200
    -------Details--------
    System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> 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: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetProperties(String Item, Property[] Properties, Property[]& Values)
       at Microsoft.ReportingServices.WebServer.ReportingService2010.GetProperties(String ItemPath, Property[] Properties, Property[]& Values)

       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

       at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.GetProperties(String ItemPath, Property[] Properties)

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass13.<GetProperties>b__12()

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()

       at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.GetProperties(String itemPath, Property[] properties)

       at Microsoft.ReportingServices.UI.ReportingWebControl.GetItemProperties(String itemPath, String[] properties)

       at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)

       at System.EventHandler.Invoke(Object sender, EventArgs e)

       at System.Web.UI.Control.OnInit(EventArgs e)

       at System.Web.UI.Page.OnInit(EventArgs e)

       at System.Web.UI.Control.InitRecursive(Control namingContainer)

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    library!ReportServer_0-2!136c!12/08/2010-15:16:51:: Call to GetSystemPropertiesAction().
    ui!ReportManager_0-1!a0c!12/08/2010-15:16:51:: e ERROR: System.Threading.ThreadAbortException: Thread was being aborted.
       at System.Threading.Thread.AbortInternal()
       at System.Threading.Thread.Abort(Object stateInfo)
       at System.Web.HttpResponse.End()
       at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
    library!WindowsService_0!143c!12/08/2010-15:17:41:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
    notification!WindowsService_0!143c!12/08/2010-15:17:41:: i INFO: Handling subscription a96ce111-5931-41ac-a82d-8226f75740a0 to report daily_briefing_worldspan_NS_New, owner: WORLDSPAN\DOthman, delivery extension: Report Server FileShare.
    library!WindowsService_0!143c!12/08/2010-15:17:41:: i INFO: RenderForNewSession('/Service Center/DataCenter Reports/daily_briefing_worldspan_NS_New')
    library!WindowsService_0!143c!12/08/2010-15:17:44:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties.
    library!WindowsService_0!143c!12/08/2010-15:17:44:: Using folder D:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
    library!WindowsService_0!143c!12/08/2010-15:17:46:: i INFO: Initializing StoredParametersThreshold to '1500' characters as specified in Server system properties.
    library!WindowsService_0!143c!12/08/2010-15:17:46:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
    library!WindowsService_0!143c!12/08/2010-15:17:46:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
    subscription!WindowsService_0!143c!12/08/2010-15:18:07:: e ERROR: Failure writing file \\busihppnas0040v\webapps\dc\ws\daily_briefing_worldspan_NS_New\outages_and_availability_summary\outages_and_availability_summary_SQL.htm : System.IO.IOException: The network path was not found.

       at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
       at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
       at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
       at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d)
    subscription!WindowsService_0!143c!12/08/2010-15:18:07:: i INFO: Error writing file outages_and_availability_summary_SQL.htm to path \\busihppnas0040v\webapps\dc\ws\daily_briefing_worldspan_NS_New\outages_and_availability_summary
    notification!WindowsService_0!143c!12/08/2010-15:18:07:: e ERROR: Error occured processing subscription a96ce111-5931-41ac-a82d-8226f75740a0: Failure writing file \\busihppnas0040v\webapps\dc\ws\daily_briefing_worldspan_NS_New\outages_and_availability_summary\outages_and_availability_summary_SQL.htm : The network path was not found.

    library!ReportServer_0-2!1278!12/08/2010-15:18:48:: Call to GetPermissionsAction(/).
    library!ReportServer_0-2!14e4!12/08/2010-15:18:48:: Call to GetPropertiesAction(/, PathBased).

    ==============================================end======================================================

    I have restarted the RS server and recreated the connection to the existing database , but still get the same errors

     

    Thanks for you help

    thx

     

     

    Wednesday, December 08, 2010 3:52 PM

All replies

  • Hi daotman,

    Is there any message prompted/displayed when you access the report manager? and can you access it on the report server?

    thanks,
    Jerry

    Thursday, December 09, 2010 3:01 AM
  •  

    An error occurred within the report server database This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

    I get the same message on the report server

    This is a new installation of ssrs 2008 R2 with with a migrated 2005 RS database

    thx

     

    Thursday, December 09, 2010 1:39 PM
  • Now it seems to be working and I can flip through all the pages , but I can't open any of the reports

    getting error

    An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

    Number must be either non-negative and less than or equal to Int32.MaxValue or -1. Parameter name: timeout

     

    Any ideas?

     

     

    Friday, December 10, 2010 3:45 PM
  • I am also facing similar issue in my RS, where when I try to access the reports through URL, its getting timed out. Please share the resolution. What was done to resolve the issue?

    Monday, December 09, 2013 10:22 AM