Installation of Report Manager failed, in setup.log shows "RSA_CREATE_REPORT_SOAP_FAILURE" when uploading the Executive Summary Report to Sql Server Reporting Services

Last Modified

Tue Jul 23 16:30 GMT 2019

Description

  • C:\Program Files (x86)\N-able Technologies\Report Manager\logs\setup.log shows the following:
    • [23-7-2019 14:35:05][6944][n-compass-setup-configurator][][INFO] Report Name: Executive Summary Report  ... [23-7-2019 14:35:05][6944][n-compass-setup-configurator][][INFO] There was a problem creating the report in reporting services. Retrying.[23-7-2019 14:35:05][6944][n-compass-setup-configurator][][ERROR] Error uploading Executive Summary Report: System.Exception: An error Occurred when sending the report to the SSRS. Error occurred when uploading to Reporting Services - return code: RSA_CREATE_REPORT_SOAP_FAILURE   at com.nable.ssrshelper.UploadHelper.UploadReport(String ReportName, Int32 ReportTypeID, String ReportPath, String ConfigPath, Boolean AddTemplate, Stream ReportStream, Stream ConfigStream, String ReportFolder, ArrayList ExportExclusions)   at SetupConfigurator.LoadReports.XMLReadAndLoadReports(String path, String xmlFile)

Environment

  • N-able N-central
  • Report Manager

Solution

  • This occurs because of the large size of the "Executive Summary Report" file and a report file size limit that is set in the configuration file of SQL Reporting Services.
  • To correct this issue follow the below steps:
    1. Open Reporting Services Configuration Manager from the start menu items
    2. Select to connect to the default instance on the server
    3. From that instance, select Stop the SQL Server Reporting Services service
    4. Navigate to the SQL Reporting Services "ReportServer" folder
      • NOTE: For example C:\Program Files\Microsoft SQL Server\MSRSXX.MSSQLSERVER\Reporting Services\ReportServer
        • NOTE: XX is the SQL version number
    5. Open the web.config file in notepad
    6. Find the following line in the file:
      • <httpRuntime executionTimeout="9000" maxRequestLength="20480" />
    7. Change the value for the "maxRequestLength" as below:
      • <httpRuntime executionTimeout="9000" maxRequestLength="51200" />
    8. Save your changes to the file
    9. Open Reporting Services Configuration Manager
    10. Start the SQL Server Reporting Services service
    11. Reinstall Report Manager on the server