We recently changed over to SSL and also changed the hostname as well. Now all of our reports have the wrong URL. I'm hoping we can just make one change in the database to resolve this. Any assistance would be appreciated.
Thanks in advance!
I had this same problem, except we aren't using SSL. I had opened a ticket with Solarwinds support and was able to get this resolved for PDF's, but when I tried to attach an Excel file I still have this problem.
Anyway, the fix was to find the Solarwinds.Orion.Core.BusinessLayer.dll.config file, open it as administrator in notepad and change the "NavigationTimout" value from "00:08:00" to "00:60:00". Then run the Orion Service Manager and restart the Solarwinds Orion Module Engine service.
Hope this helps.
EDIT:
I guess this resolved the issue with the reports being sent as URLs instead of being attached as apposed sending the wrong URL.
I'm assuming you're referring to reports sent via the old sk00l scheduler here?
I’m not sure which scheduler it’s using. If I run it manually it seems to run fine. I’ll keep digging now. Here is the error from earlier.
Monthly Exchange User ReportUnable to retrieve url: BEDSWND:443/.../Report.aspx using PDF type.
That is the incorrect URL, it is now https://bedswnd.lh.com
It runs fine manually.
I believe the KB article below is what you're looking for.
SolarWinds Knowledge Base :: Sending Report Scheduler reports from an HTTPS-based Orion Web Console
I am having the exact same issue. Were you able to resolve this? It appears that the report is trying to generated without SSL, hence the error of unable to be retrieved.
Example:
Unable to retrieve url: http://EG1-PD-ORN-01:80/Orion/Report.aspx?ReportID=254 using HTML type.
It should be https://EG1-PD-ORN-01/Orion/Report.aspx?ReportID=254
Hi Kevin,
Yes, Solarwinds support assisted us with this. We had to go into the database and manually update the URL. It still had our old URL listed as the primary. Please see instructions below. Hope this helps.
The report/alert notification is looking on the Website table in the Orion database to pull up the information. You may update them as below:
Open the Database Manager
- Start > All Programs > SolarWinds Orion
- Advance Feature > Database Manager
- Expand the Database > Locate Website
- Right click Websites > Select Query table > Execute query
- Click on “Enable Table Editing” – to enable
Check the column ServerName, Port and SSLEnabled to see if this matches to your IIS settings
Once done, please restart all Orion services using Orion Service Manager and see if the issue still persist.
Please let me know if this helps or if you require further assistance.
Well, I think I found a workaround. It's not perfect and I still can't get the HTML version to generate, but it is working with PDF generated reports.
In the Edit Report Schedule, choose "Assign Webpage" and use the IP address of your Orion website with HTTPS and the report ID. IE https://10.11.30.21/Orion/Report.aspx?ReportID=254
Next, in the Actions to Execute section, I chose the following. When I had CSV/Excel/HTML selected, it still gave me some errors in retrieving, so I have settled with PDF.
Let me know if this helps.
jacob.decker Thanks! That worked perfectly :-)
Thank you! Worked perfect for us. Had the HTTP and PDF issue.
Didn't work for me. I know my issue. The certificates were installed and now the email I'm getting doesn't show https:// it still shows http:// and the files aren't attached. I'm guessing for the same reason. What else have people done to fix this? I'm trying not to mess with SQL database as I'm just a lowly network guy.
Unfortunately there's really no way of getting around needing to modify the database itself -> Enable SSL or https for the Orion Web Console - SolarWinds Worldwide, LLC. Help and Support
This fixed my issue. Thank you!
Is the marked answer in this post valid for issues with Excel Types in NPM 12? Below is my error.
Unable to retrieve url: https://Solarwinds:443/Orion/Report.aspx?ReportID=918 using Excel type.
Im experiencing the same issue as you right now, although i'm using http and not https.
Have you figured it out?
I need to use csv and excel.. only pdf works
