Labels

Not Able To Start SQL Server Reporting Services





Error : "The report server has encountered a configuration error. See the report server log files for more information. Max memory limit must be higher then memory limit." 


This is bit old issue i faced when i joined a new company and getting KT. Today my shift is changed and I came to evening shift to understand BAU. The moment I enter junior DBA told me he is not able to start Reporting services. Oh reporting services ………….. Its never been cup of my tea but still I took It as some services is not started so I jumped into this. I tired to start services by my self and greeted with error.

Error was not much informational but at least it told me that there must be something in error logs.

So first thing I check is event viewer (some thing blab la………)

/*********Error in Event viewer ******************/
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
   at Microsoft.ReportingServices.Diagnostics.ServiceConfig.ParseXML(XmlNode node)
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
   at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start...
/*********************************************/

As event viewer says, I open reporting services logs If you didn't configure explicitly, below will be your default location.

Reporting Services error log @ : C:\Program Files\Microsoft SQL Server\MSSQL.(int)\Reporting Services\LogFiles

Error log says below:
/********Error from Reporting services error log ********/


Microsoft SQL Server Reporting Services Version 9.00.5000.00
  en-US
\\errorlog location\ReportServerService__main_08_05_2013_08_50_36.log
 Microsoft Windows NT 6.1.7601 Service Pack 1
  6.1.7601.65536

ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing MemoryLimit to '8500' percent as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing RecycleTime to '1500' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing MaximumMemoryLimit to '1100' percent as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
ReportingServicesService!library!4!8/5/2013-08:50:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., Max memory limit must be higher then memory limit.  Maxmemory = 11, MemoryLimit = 85;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
ReportingServicesService!diagnostic!4!8/5/2013-08:50:36:: Error loading configuration file: The report server has encountered a configuration error. See the report server log files for more information.
ReportingServicesService!library!4!8/5/2013-08:50:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
   at Microsoft.ReportingServices.Diagnostics.ServiceConfig.ParseXML(XmlNode node)
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
   --- End of inner exception stack trace ---   --- End of inner exception stack trace ---

/************************************************************************************************************/

And as usual I searched highlighted error in Google: No Results  ….. AWWWWWWW. My jaw is wide open.
Is this never faced by any one????????

Whatever but I realize this issue is due to memory setting. I checked events occur with Junior DBA and he told me

  1. Application team was not able to see reports and the sent mail to DBA’s
  2. Junior DBA modified memory in configuration files “path of config file\ rsreportserver”
  3. Junior DBA restarted reporting services but Services never came up.


Now I realized, By mistake J DBA have changed wrong values for memory . And when I check configuration file I got the issue. I modified configuration as per my ram and now reporting services are up and running fine.
Rule is : MemoryLimit < MaximumMemoryLimit


/************************Part of config file ***************************/
                        True
                        True
                        True
                        10
                        False
                        8500
                        1500
                        11000
                        30
                        0
                        http://servername/reportserver
                       
/********************************************************************/


By mistake DBA have changed Maxmemory from 11000 to 1100. making it less than memory limit








No comments:
Write comments

Please do not enter spam links

Services

More Services