Network Management
PDF and CSV report attachment not working after changing the website of NPM to HTTPS
After changing the website of NPM to HTTPS, PDF and CSV report attachment not working. HTML report attachments may also not be working.
First published date
10/31/2018 10:28 PM
Last published date
5/4/2023 3:34 PM
Overview
The following error occurs on email reports after changing the Orion NPM website from HTTP to HTTPS:
Unable to retrieve url: https://<Server Name>:443/Orion/Report.aspx?ReportID=***using PDF type. Unable to retrieve url: https://<Server Name>:443/Orion/Report.aspx?ReportID=*** using CSV type. Unable to retrieve url: https://<Server Name>:443/Orion/Report.aspx?ReportID=*** using HTML type.
However, generating the report manually works fine from the Orion Web Console.
Product section
Network Performance Monitor
Cause
The issue is caused when HTTPS is not correctly configured on the Orion NPM server.
Resolution
Important: All Unassigned IP Addresses must be used when you click the Edit Bindings on the Orion Website via IIS Manager.
- Launch the Orion Database Manager from the Orion server. Click Start > All Programs > SolarWinds Orion.
- From the Orion Database Manager, click Add Default Server. This will connect to the SQL server hosting the SolarWinds database.
- Expand the SQL server and look for the SolarWinds database in bold.
- Expand the SQL database and look for Websites table.
- Right-click Websites table and select Query Table.
- Click Execute Query. To change the value of the table, click Enable Table Editing.
- The Servername must be set to FQDN of the Orion Server, for example, servername.domain.com.
- SSLEnabled must be set to 1, and the Port is set to 443.
- IPAddress field should be (All Unassigned).
- The FQDN field needs a name DNS will recognize and that matches the DNS name field in the certificate.
- Press Enter after editing and select Execute Query again to ensure the changes have been committed to the database.
- Restart all Orion services via Orion Service Manager.