Hi there -- Several times a day we have to restart the SQL Reporting Service when it appears to hang. Below is an example of the log files: ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing SecureConnectionLevel to '3' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file. ReportingServicesService!servicecontroller!1428!8/17/2008-12:05:40:: Total Physical memory: 2146902016 ReportingServicesService!resourceutilities!12dc!8/17/2008-12:05:40:: i INFO: Reporting Services starting SKU: Developer ReportingServicesService!servicecontroller!12dc!8/17/2008-12:05:40:: i INFO: RPC Server started ReportingServicesService!servicecontroller!12dc!8/17/2008-19:05:36:: i INFO: RPC Server stopped ReportingServicesService!servicecontroller!12dc!8/17/2008-19:05:37:: Service shutting down. Any ideas? Thanks in advance. - Mikki
The log file looks to me like it is showing what happens after you shut it down and start it back up (i.e. all the initialization). It is not showing anything to help diagnose why it was frozen. What version is this? RS 2000 or RS 2005? -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Mikki" wrote in message news:2DA6FA6C-5BD8-4B67-9110-D460A2DC5233@microsoft.com... > Hi there -- > > Several times a day we have to restart the SQL Reporting Service when it > appears to hang. Below is an example of the log files: > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing ConnectionType to '0' as specified in Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing IsSchedulingService to 'True' as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing IsNotificationService to 'True' as specified in > Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing IsEventService to 'True' as specified in Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing PollingInterval to '10' second(s) as specified in > Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing MemoryLimit to '60' percent as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing RecycleTime to '720' minute(s) as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing MaximumMemoryLimit to '80' percent as specified in > Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing MaxQueueThreads to '0' thread(s) as specified in > Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing MaxScheduleWait to '5' second(s) as specified in > Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing DatabaseQueryTimeout to '120' second(s) as specified in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing ProcessRecycleOptions to '0' as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified > in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing RunningRequestsDbCycle to '60' second(s) as specified in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing RunningRequestsAge to '30' second(s) as specified in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing CleanupCycleMinutes to '10' minute(s) as specified in > Configuration file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing SecureConnectionLevel to '3' as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing DisplayErrorLink to 'True' as specified in Configuration > file. > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > Initializing WebServiceUseFileShareStorage to default value of 'False' > because it was not specified in Configuration file. > ReportingServicesService!servicecontroller!1428!8/17/2008-12:05:40:: Total > Physical memory: 2146902016 > ReportingServicesService!resourceutilities!12dc!8/17/2008-12:05:40:: i > INFO: > Reporting Services starting SKU: Developer > ReportingServicesService!servicecontroller!12dc!8/17/2008-12:05:40:: i > INFO: > RPC Server started > ReportingServicesService!servicecontroller!12dc!8/17/2008-19:05:36:: i > INFO: > RPC Server stopped > ReportingServicesService!servicecontroller!12dc!8/17/2008-19:05:37:: > Service > shutting down. > > Any ideas? Thanks in advance. > - Mikki >
I have the same problem with SQL 2000 RS. I unchecked the recycle worker processes and that seemed to help. Instead of it locking up a couple times a week, it goes about a month. However, it still sometimes hangs when trying to login to the reports admin screen. I then restart IIS and it works again. For a couple years, RS worked perfectly. We have added more websites to that server for flex, etc. But, I don't know how to solve this problem permanently. I setup a scheduled task to do a IIS reset once every other week but I don't like that option. Any ideas? Thanks "Bruce L-C [MVP]" wrote: > The log file looks to me like it is showing what happens after you shut it > down and start it back up (i.e. all the initialization). It is not showing > anything to help diagnose why it was frozen. > > What version is this? RS 2000 or RS 2005? > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Mikki" wrote in message > news:2DA6FA6C-5BD8-4B67-9110-D460A2DC5233@microsoft.com... > > Hi there -- > > > > Several times a day we have to restart the SQL Reporting Service when it > > appears to hang. Below is an example of the log files: > > > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing ConnectionType to '0' as specified in Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing IsSchedulingService to 'True' as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing IsNotificationService to 'True' as specified in > > Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing IsEventService to 'True' as specified in Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing PollingInterval to '10' second(s) as specified in > > Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing MemoryLimit to '60' percent as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing RecycleTime to '720' minute(s) as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing MaximumMemoryLimit to '80' percent as specified in > > Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing MaxQueueThreads to '0' thread(s) as specified in > > Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing MaxScheduleWait to '5' second(s) as specified in > > Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing DatabaseQueryTimeout to '120' second(s) as specified in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing ProcessRecycleOptions to '0' as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing RunningRequestsScavengerCycle to '60' second(s) as specified > > in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing RunningRequestsDbCycle to '60' second(s) as specified in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing RunningRequestsAge to '30' second(s) as specified in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing CleanupCycleMinutes to '10' minute(s) as specified in > > Configuration file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing SecureConnectionLevel to '3' as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing DisplayErrorLink to 'True' as specified in Configuration > > file. > > ReportingServicesService!library!12dc!8/17/2008-12:05:39:: i INFO: > > Initializing WebServiceUseFileShareStorage to default value of 'False' > > because it was not specified in Configuration file. > > ReportingServicesService!servicecontroller!1428!8/17/2008-12:05:40:: Total > > Physical memory: 2146902016 > > ReportingServicesService!resourceutilities!12dc!8/17/2008-12:05:40:: i > > INFO: > > Reporting Services starting SKU: Developer > > ReportingServicesService!servicecontroller!12dc!8/17/2008-12:05:40:: i > > INFO: > > RPC Server started > > ReportingServicesService!servicecontroller!12dc!8/17/2008-19:05:36:: i > > INFO: > > RPC Server stopped > > ReportingServicesService!servicecontroller!12dc!8/17/2008-19:05:37:: > > Service > > shutting down. > > > > Any ideas? Thanks in advance. > > - Mikki > > > > >
