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 ********/
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
- Application team was not able to see reports and the sent mail to DBA’s
- Junior DBA modified memory in configuration files “path of config file\ rsreportserver”
- 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 ***************************/
/********************************************************************/
By
mistake DBA have changed Maxmemory from 11000 to 1100. making it less than memory limit
No comments:
Post a Comment