Network Management

Unable to retrieve URL using Excel when exporting report using SolarWinds Platform

Receives an error message on the email when a scheduled report is sent - Unable to retrieve URL using Excel type.

First published date

10/24/2018 8:43 AM

Last published date

8/16/2025 12:06 AM

Overview

A scheduled custom table report can be configured to be exported in CSV, HTML, or Excel format. This article describes an issue where emails received from scheduled reports contain a message

 

Unable to retrieve URL using Excel type.

Unable to retrieve URL error when exporting an XLS file.

Unable to retrieve URL: http://servername:80/Orion/Report.aspx?/ReportID=559 using excel type

 

Product section

Orion Platform

Cause

This error is caused by any of the following:

  • The URL cannot be retrieved because of incorrect binding settings for the website.
  • The report is exporting raw data from a chart or report.
  • SolarWinds Platform is unable to access its own site using the parameters set in the Websites table.

Error found in ActionsExecutionReport

ERROR ReportingLogger - (null) Error during fetching url: http://<serverhostname>:80/Orion/Report.aspx?ReportID=874 using Excel type System.ArgumentException: Illegal characters in path. ERROR ReportingLogger - (null)  Error during fetching url: https://<serverhostname>:443/Orion/Report.aspx?ReportID=5221 using Excel type System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.    
at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)    
at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)    
at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest, Boolean renegotiation)

Resolution

The URL cannot be retrieved because of incorrect binding settings for the website.
 

Solution 1:

  1. Go to IIS and change the bindings to All Unassigned. Refer to Add or Edit Site Binding Dialog Box (© 2017 Microsoft, available at https://technet.microsoft.com/, obtained on June 20, 2017.).
  2. Rerun the reports.

Steps with screenshots:

  1. Open IIS Manager.
  2. Right-click the SolarWinds website, and then select Edit Bindings.

    (Screenshot property of © 2019 Microsoft)
  3. Highlight the binding, and then select Edit.
  4. Under IP address, select All Unassigned in the drop-down menu.


(Screenshot property of © 2019 Microsoft)


Solution 2:

Check the expiration of the SSL certificates.


Solution 3:

Ensure the Website table contains the correct ServerName and FQDN
 

  1. Go to Start > SolarWinds Orion > Advanced Features > Database Manager
  2. Click Add default server.
  3. Right-click on SolarWindsOrion database and select New query.
  4. Open Websites table and execute the query to view.
  5. To update the server name press Enable Table Editing 
  6. If the user needs to access the web console via an FQDN and the FQDN is covered by the SSL certificate, update it in the FQDN field


The report is exporting raw data from a chart or report.

Recreate or modify the chart or report and use Custom Table instead of Custom Report when exporting the raw data.
 

Solution 4:

If you do not wish to use a self-signed certificate, make sure you have added the 3rd party certificate on the trusted ones. Please review this article for further details.


​​Solution 5:

Remove Special characters in the title of the report.

​​Solution 6:

Steps with screenshots:

  1. RDP to the application server
  2. Open IIS
  3. Right-click the SolarWinds website, and then select Edit Bindings.
    image.png
    (Screenshot property of © 2019 Microsoft)

4. Highlight the binding, and then select Edit.
5. Check the site binding ports used
image.png
(Screenshot property of © 2019 Microsoft)

Ensure the Website table contains the correct Server Name and FQDN

  1. Go to Start > SolarWinds Orion > Advanced Features > Database Manager
  2. Click Add default server.
  3. Right-click on SolarWindsOrion database and select New query.
  4. Open the Websites table and execute the query to view.
  5. To update the Port and SSL Enabled press Enable Table Editing 
  6. Change the value of Port to 443 and SSL Enabled to 1

image.png
         7.  Run the report once again it will work using the HTTPS URL 

*You can also run the Configuration Wizard on the Web Server to properly sync the website.