SSRS 2008 R2 failing to restart

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SSRS 2008 R2 failing to restart

Author

Topic

nman47
Starting Member

8 Posts

Posted - 2011-04-08 : 15:17:05

We upgraded our SQL Server Reporting services to the new SSRS 2008 R2 version from SSRS 2008 just last February. Since then we have been randomly having problems restarting the service.

Any help or suggestion is greatly appreciated.

Server Specs:
Windows Server 2003 R2 64bit
Total memory of 16GB
SQL Server 2008 R2 (10.50.1600)

When looking at the log, this is what I see....

dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!1f30!04/08/2011-07:20:05:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!1e38!04/08/2011-07:20:05:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
dbpolling!WindowsService_0!15e0!04/08/2011-07:20:05:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
dbpolling!WindowsService_0!1668!04/08/2011-07:20:05:: i INFO: PollingMaintenance: Polling started
resourceutilities!WindowsService_0!1668!04/08/2011-07:20:05:: i INFO: Maximum memory limit is 2097152Mb
rpcserver!DefaultDomain!1f30!04/08/2011-07:20:05:: e ERROR: RpcServerUseProtseqEp failed. Status=1740.
appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:05:: i INFO: The UserAccountControl value for the service account is 66048
rshost!rshost!113c!04/08/2011-07:20:05:: e ERROR: Failed to register url=http://+:80/ReportServer/ for endpoint 2, error=b7.
rshost!rshost!113c!04/08/2011-07:20:05:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.
servicecontroller!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
servicecontroller!DefaultDomain!1f30!04/08/2011-07:20:06:: e ERROR: Exception caught starting RPC server: System.Runtime.InteropServices.COMException (0x800706CC): The endpoint is a duplicate. (Exception from HRESULT: 0x800706CC)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcServer.RpcServer.StartServer(String rpcEndpointName, Byte[] webServiceUserSid, Object pNativeDelegation, Object pUnmanagedHost, String dumpLocation, String instanceName, String serviceName, Int32 dumperFlags, Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:06:: i INFO: The UserAccountControl value for the service account is 66048
rshost!rshost!914!04/08/2011-07:20:06:: e ERROR: Failed to register url=http://+:80/Reports/ for endpoint 3, error=b7.
rshost!rshost!914!04/08/2011-07:20:06:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager.
servicecontroller!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Error creating HTTP endpoint. System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String[] hosts, Int32 cHosts, Boolean wildCardPresent, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Int32 extendedProtectionLevel, Int32 extendedProtectionScenario, Boolean enabled)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
rshost!rshost!166c!04/08/2011-07:20:06:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
resourceutilities!DefaultDomain!1928!04/08/2011-07:20:06:: i INFO: Maximum memory limit is 2097152Mb
rshost!rshost!1928!04/08/2011-07:20:06:: i INFO: Derived memory configuration based on physical memory as 16771724 KB
library!WindowsService_0!1204!04/08/2011-07:20:06:: i INFO: Schedule 59d035f5-da30-439d-9ea5-c100e26571ba executed at 04/08/2011 07:20:06.
library!WindowsService_0!1c44!04/08/2011-07:20:06:: i INFO: Schedule af16b59b-9f99-4700-917c-b79d0c513ccb executed at 04/08/2011 07:20:06.
library!WindowsService_0!16b0!04/08/2011-07:20:06:: i INFO: Schedule ab1d6d21-6862-493d-8543-8063e41361a8 executed at 04/08/2011 07:20:06.
schedule!WindowsService_0!1c44!04/08/2011-07:20:06:: Creating Time based subscription notification for subscription: 477aeadd-f2ae-4ad0-b81b-a575bab9167c
schedule!WindowsService_0!16b0!04/08/2011-07:20:06:: Creating Time based subscription notification for subscription: d9de7aa8-eed6-4d3b-b2b9-4cb245ad9e18
schedule!WindowsService_0!1204!04/08/2011-07:20:06:: Creating Time based subscription notification for subscription: 6e9348c1-453d-41c0-8086-fbd990f090d9
servicecontroller!DefaultDomain!1cd0!04/08/2011-07:20:06:: i INFO: Total Physical memory: 17174245376
rpcserver!DefaultDomain!18d8!04/08/2011-07:20:06:: i INFO: Process monitoring started.
appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Either another process ReportingServicesService instance is already running or another application with the RPC endpoint ReportingServices$MSRS10_50.MSSQLSERVER is running.
appdomainmanager!DefaultDomain!1928!04/08/2011-07:20:06:: e ERROR: Appdomain:1 DefaultDomain failed to initialize. Error: System.Exception: RPC Server failed to start.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartInternal(Object parentThread).
appdomainmanager!WindowsService_0!1f30!04/08/2011-07:20:06:: e ERROR: Appdomain:2 WindowsService_0 failed to initialize. Error: The endpoint cannot be created.
appdomainmanager!DefaultDomain!f18!04/08/2011-07:20:06:: e ERROR: Windows service failed to start. Exception: System.Exception: Default appdomain failed to initialize.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args)
library!WindowsService_0!1204!04/08/2011-07:20:06:: i INFO: Schedule 59d035f5-da30-439d-9ea5-c100e26571ba execution completed at 04/08/2011 07:20:06.
library!WindowsService_0!16b0!04/08/2011-07:20:06:: i INFO: Schedule ab1d6d21-6862-493d-8543-8063e41361a8 execution completed at 04/08/2011 07:20:06.
library!WindowsService_0!1c44!04/08/2011-07:20:06:: i INFO: Schedule af16b59b-9f99-4700-917c-b79d0c513ccb execution completed at 04/08/2011 07:20:06.
rpcserver!DefaultDomain!18d8!04/08/2011-07:20:06:: i INFO: Process monitoring stopped.
rpcserver!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: RPC Server stopped.
servicecontroller!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: RPC Server stopped.
servicecontroller!WindowsService_0!1a18!04/08/2011-07:20:06:: i INFO: Service controller exiting.
dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: EventPolling polling service stopped
dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: NotificationPolling polling service stopped
dbpolling!WindowsService_0!1e38!04/08/2011-07:20:06:: i INFO: HeartbeatThread(EventPolling): Exited.
dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: SchedulePolling polling service stopped
dbpolling!WindowsService_0!1594!04/08/2011-07:20:06:: i INFO: UpgradePolling polling service stopped
appdomainmanager!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: Appdomain:2 WindowsService_0 unregistered.
appdomainmanager!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: Appdomain:2 WindowsService_0 unloading.
appdomainmanager!DefaultDomain!1e38!04/08/2011-07:20:06:: i INFO: AppDomain:2 0 pending unload(s)
library!WindowsService_0!1c44!04/08/2011-07:20:06:: e ERROR: Queue item has unhandled exception. System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
at Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
at Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object state)
dbpolling!WindowsService_0!1c44!04/08/2011-07:20:06:: e ERROR: Queue worker thread caught unhandled exception: System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object state)
appdomainmanager!DefaultDomain!1ce8!04/08/2011-07:20:06:: i INFO: Appdomain:2 unregistered.
rshost!rshost!1ce8!04/08/2011-07:20:06:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.
servicecontroller!DefaultDomain!1a18!04/08/2011-07:20:06:: i INFO: Service shutting down.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-08 : 15:19:00

I think you need to open a case with the PSS team at Microsoft. The error logs are typically too cryptic for us to help over the Internet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources