locked
sql server reporting service RRS feed

  • Question

  • Hi All,

    We were receiving many tickets saying sql reporting service was down yesterday.

    Its reported that the sql reporting service was automatically restarting for sometime yesterday.

    We see a msg 'Service started successfully' with event id: 0 intermittently for 2 hours. There were no logs that the service got stopped. We have only logs saying the service started successfully.

    We dont see any errors except the below in eventvwr when the reporting service was restarted:

    (Application error)
    Faulting application name: SQLPS.exe, version: 12.0.2000.8, time stamp: 0x5306bda0
    Faulting module name: KERNELBASE.dll, version: 6.3.9600.19358, time stamp: 0x5ccfa112

    (.Net Runtime error)
    Application: SQLPS.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.OutOfMemoryException

    Could you please help me in understanding the cause?


    Monday, October 14, 2019 7:13 AM

Answers

  • Do you user any powershell commands to deploy perhaps SSRS folder for example

    You need to look at the log files in the following directory:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    (Assuming you're running 2008R2) Your directory may differ slightly. When the service starts or restarts a new logfile is created.


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Zoe Gu Wednesday, October 16, 2019 5:43 AM
    • Marked as answer by SSG92 Thursday, January 2, 2020 5:18 PM
    Tuesday, October 15, 2019 8:04 AM

All replies

  • We were receiving many tickets saying sql reporting service was down yesterday.

    We don't know your ticketsystem and what it is doing, so i can't say.

    SqlPs is SQL Powershell, has nothing to do with Reporting Servies.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, October 14, 2019 7:21 AM
  • Hi Olaf,

    Thanks for the reply.

    Below is the alert we received:

    SQLServer (ReportServer) windows service DOWN on xxxx on host:<server name>:reportserver -  Host scale-<server name> with IP yyyyyyyy.

    In event viewer, we have only the  below log for sql reporting services. We see this log repeatedly for 2 hours.

    "Service started successfully"

    event id: 0

    There are no logs for the service getting stopped. What could be the reason. 

    Monday, October 14, 2019 7:50 AM
  • Do you user any powershell commands to deploy perhaps SSRS folder for example

    You need to look at the log files in the following directory:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    (Assuming you're running 2008R2) Your directory may differ slightly. When the service starts or restarts a new logfile is created.


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Zoe Gu Wednesday, October 16, 2019 5:43 AM
    • Marked as answer by SSG92 Thursday, January 2, 2020 5:18 PM
    Tuesday, October 15, 2019 8:04 AM