ReportingServicesService hangs up the Server

Question

Something strange has happened with Reporting Services on the server. When the ReportingServicesService windows service is runnig, it loads CPU (up to 100%) and allocates more and more virtual memory (up to 1,5Gb). There aren't subscriptions for the Report Server and nobody permanently executes reports on it. How can I fix that memory leak?

Log during memory leak:
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!4/12/2007-15:39:48:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
ReportingServicesService!servicecontroller!9!4/12/2007-15:39:49:: Total Physical memory: 3220504576
ReportingServicesService!servicecontroller!4!4/12/2007-15:39:49:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
ReportingServicesService!library!a!4/12/2007-15:39:49:: i INFO: Catalog SQL Server Edition = Enterprise
ReportingServicesService!resourceutilities!a!4/12/2007-15:39:49:: i INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!resourceutilities!a!4/12/2007-15:39:49:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!crypto!a!4/12/2007-15:42:46:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!a!4/12/2007-15:42:46:: i INFO: Exporting public key
ReportingServicesService!crypto!a!4/12/2007-15:42:47:: i INFO: Performing sku validation
ReportingServicesService!crypto!a!4/12/2007-15:42:52:: i INFO: Importing existing encryption key
ReportingServicesService!servicecontroller!1b!4/12/2007-15:45:46:: i INFO: RPC Server stopped
ReportingServicesService!servicecontroller!1b!4/12/2007-15:46:06:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!1b!4/12/2007-15:46:23:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!1b!4/12/2007-15:46:39:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!1b!4/12/2007-15:46:56:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!1b!4/12/2007-15:47:13:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!1b!4/12/2007-15:47:29:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!1b!4/12/2007-15:47:46:: Can't unload domain, trying again

Answer 1

I have the same problem. Reporting Services 2005 used up to 1.5GB of memory on my dev server. The reports are not big, no more than 500 records. Sometimes memory can ramp up as much as .5 G when running a single report. Once the memory is consumed it doens't get released unless I reboot the machine. What can we do to addresss this problem?

Answer 2

I recently noticed a similar thing on my MSReports server.  I do not know if it hogs up memory, but it is frequently crashing the service.  Unfortunately it is running on Windows Server 2000 Standard.  We're on SQL Server 2005 SP2, MSReports running on a separate machine.  Anyone seen a similar problem and actually been able to fix it?

Tail end of one service_main log before this happened:

ReportingServicesService!servicecontroller!9!8/28/2008-01:55:05:: i INFO: Recycling the service from default domain
ReportingServicesService!servicecontroller!9!8/28/2008-01:55:06:: i INFO: New app domain started
ReportingServicesService!servicecontroller!9!8/28/2008-02:11:15:: i INFO: Recycling app domain because polling threads are not active.
ReportingServicesService!servicecontroller!9!8/28/2008-02:11:15:: i INFO: Recycling the service from default domain
ReportingServicesService!servicecontroller!9!8/28/2008-02:11:17:: i INFO: New app domain started
ReportingServicesService!servicecontroller!9!8/28/2008-02:35:33:: i INFO: Recycling app domain because polling threads are not active.
ReportingServicesService!servicecontroller!9!8/28/2008-02:35:33:: i INFO: Recycling the service from default domain
ReportingServicesService!servicecontroller!9!8/28/2008-02:35:44:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:35:57:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:36:10:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:36:23:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:39:15:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:39:28:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:39:41:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:39:54:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:40:07:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:41:48:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:42:01:: e ERROR: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!8/28/2008-02:42:02:: e ERROR: Unable to unload app domain, terminating process

 

Also getting a lot of upgrade errors in another service log, but more frequently.  Not sure if this is relevant:

   at Microsoft.ReportingServices.Library.Security.GetPolicies(String itemName, Boolean& inheritParent, String& xmlPolicy)
   at Microsoft.ReportingServices.Library.UpgradeSecurityDescriptor.SecurityDescriptorItemInfo.Upgrade(Storage storage)
   at Microsoft.ReportingServices.Library.UpgradeMultipleItemsTask.UpdateItems(ItemCollection items)
ReportingServicesService!library!c!8/28/2008-07:12:43:: Error on upgrade UpgradedSecurityDesc for item: /Billing
ReportingServicesService!library!c!8/28/2008-07:12:43:: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ReportingServices.Library.Security.GetPolicies(String itemName, Boolean& inheritParent, String& xmlPolicy)
   at Microsoft.ReportingServices.Library.UpgradeSecurityDescriptor.SecurityDescriptorItemInfo.Upgrade(Storage storage)
   at Microsoft.ReportingServices.Library.UpgradeMultipleItemsTask.UpdateItems(ItemCollection items)
ReportingServicesService!library!c!8/28/2008-07:12:43:: Error on upgrade UpgradedSecurityDesc for item: /Billing/Increase
ReportingServicesService!library!c!8/28/2008-07:12:43:: System.NullReferenceException: Object reference not set to an instance of an object.

Answer 3

Does anyone got resolved this issue. I am getting the same problem in my production SQL reporting server. Any help would be helpful!

 

Answer 4

Hi,

I'm also facing the same problem, any help?

---

- JL

Answer 5

I think this is something you should open a case with Customer Support Services to investigate the issue.  It would be difficult to come up with an answer in the forum.

Hope that helps,
-Lukasz

---

Got a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

I had a similar issue. I updated the UpgradedSecurityDesc and UpgradeConnectionEncrytion in the UpgradeInfo table to both equal True. Restarted Report Server service and then it worked.

Answer 7

Thanks for the detailed info in this post. SSRS used to have upgrade bug. It was fixed for SSRS 2000 -> 2008 upgrade, but not for SSRS 2000 -> 2005 upgrade. We’ll make sure to trace/fix this problem. Without getting into the technical details, I can just say that mentioned bug prevents 1) proper initializing of a Windows service domain 2) sometimes - unloading of a Windows service domain. #1 causes RS trying to recreate Windows service domain multiple times, #2 causes multiple instances of Windows service domain stay in memory. Every domain has its own copy of RS libraries resulting in large memory footprint. After 10 unsuccessful attempts to unload same domain, RS kills the process (crash).

 

Workaround proposed by aspbegineer83 looks acceptable. Just limit it to setting [UpgradeInfo].UpgradedSecurityDesc = True. Then RS will skip upgrading item security descriptors (where bug lives). To my knowledge it should not cause security access problems.  But if it does, you can fix it by resetting security on items where problem occurs. Making DB backup would be a good idea before changing UpgradeInfo table.

 

Igor

 

 

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 8

Does this apply for non upgraded SSRS 2005 as well?

I got this in my log last night:

ReportingServicesService!servicecontroller!9!2010-06-08-00:00:09:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:00:21:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:00:33:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:00:44:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:00:56:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:01:08:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:01:20:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:01:31:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:01:43:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:01:55:: Can't unload domain, trying again
ReportingServicesService!servicecontroller!9!2010-06-08-00:01:56:: Unable to unload app domain, terminating process

I had a scheduled report running...

Tomas

Answer 9

Yo tenía el mismo problema y era porque tenía una imagen en el reporte y cuando se iba a generar el excel salío error de renderizado, asi que quité la imagen y le di Deploy al reporte y ya generó bien.

Espero sea de ayuda.