I know that ssrs will sleep when no reports are run for x hpurs, this will free up ram... I'm completely guessing but maybe that is what is going on.....
component SMS_SRS_REPORTING_POINT on computer severName.domain.com reported
I keep seeing the error below in the Event Viewer.
On 2/16/2021 5:26:00 AM, component SMS_SRS_REPORTING_POINT on computer serverName.domain.com reported: The report server service is not running on Reporting Service Point server "serverName.domain.com"; start the service to enable reporting.
I'm seeing the same error in this thread but I'm running SQL Server 2019 and NOT 2008 so I don't think the "Cumulative Update package 4 for SQL Server 2008 R2" will help. Any other suggestion?
7 answers
Sort by: Newest
-
-
CharlieLor 551 Reputation points
2021-02-22T20:52:23.437+00:00 I don't see any significant information from the following information.
From: Event Viewer (Local) Application
Log Name: Application Source: SMS Server Date: 2/21/2021 4:10:36 AM Event ID: 7403 Task Category: SMS_SRS_REPORTING_POINT Level: Error Keywords: Classic User: N/A Computer: DevDB.example.com Description: On 2/21/2021 4:10:36 AM, component SMS_SRS_REPORTING_POINT on computer DevDB.example.com reported: The report server service is not running on Reporting Service Point server "DevDB.example.com"; start the service to enable reporting. <Data>On 2/21/2021 4:10:36 AM, component SMS_SRS_REPORTING_POINT on computer DevDB.example.com reported: </Data>
From: ReportingServicesService_2021_02_21_00_00_10.log
appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:01:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:01:: i INFO: Shrink notification can be sent to appdomain 'ReportServer_SSRS_0-4-132583325174756345' (id = '9') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:08:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:08:: i INFO: Shrink notification can be sent to appdomain 'ReportServer_SSRS_0-4-132583325174756345' (id = '9') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:13:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:13:: i INFO: Shrink notification can be sent to appdomain 'ReportServer_SSRS_0-4-132583325174756345' (id = '9') since it is being unloaded now or it is marked for an upcoming unload operation appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:16:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation
-
Garth Jones 2,076 Reputation points
2021-02-22T17:51:21.263+00:00 I would review the SSRS log to see what it says happened at that time.
-
CharlieLor 551 Reputation points
2021-02-22T16:02:44.28+00:00 I use Get-Status ServiceName and run the script every 5 minutes. Perhaps the service could have died between that 5 minutes increment. But let's assumed that service did stop, what are some other options on troubleshooting it further to determine the cause of it?
-
Garth Jones 2,076 Reputation points
2021-02-19T20:41:39.003+00:00 How does your powershell script check that the service is running? aka why believe it over the event viewer?