17 Replies Latest reply on May 9, 2017 9:24 AM by foonly

Scheduled reports only show the login page

jest4kicks May 20, 2016 1:50 PM

This question has come up before, but most of the threads were based on the previous version of the report scheduler.

Referring to the current version (11.5.2), I'm not having any luck getting scheduled reports to deliver properly. I'm using the PDF output option, but the PDF only displays an image of the login page, with the message "Enable cookies to login" below it.

Here's what I know:

- The report works fine when opened manually

- The audit log shows "User NT AUTHORITY\SYSTEM logged out from xx.xx.xx.xxx." when the scheduled report is ran.

- The solarwinds website is configured as a trusted site on the server (via the normal name we access it by, and the server's name)

- IESC is turned off on the Solarwinds server.

One thread I found mentioned changing the "Select which user account limitations should apply to the report schedule" setting. I gave that a shot, first with a report service account, and then with my admin account just to be sure. No affect.

In other threads, I've seen some folks mention switching up IIS authentication methods. We rely on SSO, and therefore use Windows Authentication. I'm extremely reluctant to modify that setting.

Has anyone managed to solve this one yet?

Re: Scheduled reports only show the login page

vehshya Jun 2, 2016 8:07 PM (in response to jest4kicks)

I've got the same issue as you. I just submitted a ticket to support. I will let you know if we are able to find a solution.

Have you had any luck with this issue since posting?
Like Show 0 Likes(0)

Actions
- Re: Scheduled reports only show the login page
  
  jest4kicks Jun 3, 2016 11:52 AM (in response to vehshya)
  
  No luck here. Didn't have time to keep cracking at it, but very anxious to see how your case turns out!
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Scheduled reports only show the login page
    
    vehshya Jun 3, 2016 11:55 AM (in response to jest4kicks)
    
    I ended up closing my case. If you read my post below, I was able to resolve the issue with those changes.
    
    Like Show 0 Likes(0)
    
    Actions
Re: Scheduled reports only show the login page

neomatrix1217 Jun 2, 2016 9:35 PM (in response to jest4kicks)

Have you tried the suggestions from this page Scheduled report only shows login page - SolarWinds Worldwide, LLC. Help and Support
2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
- Re: Scheduled reports only show the login page
  
  jest4kicks Jun 3, 2016 11:54 AM (in response to neomatrix1217)
  
  That article references earlier versions of Orion, but I did try using my admin creds in the only available credential fields in the scheduled report. No change.
  
  Like Show 1 Likes(1)
  
  Actions
Re: Scheduled reports only show the login page

vehshya Jun 3, 2016 10:35 AM (in response to jest4kicks)
I was able to get the report to run correctly by adding an additional task that saves the file locally.

Edit Report Schedule
Actions
Actions to Execute
Add Action button
Add the action "Save To Disk"
Complete the process
Commit changes

I don't know for sure if this change resolve the issue, but its the only thing that has been change since my last attempt.

Edit: I also changed:
Edit Report Schedule
Actions
Properties to Execute
Change the Report Assigned as a "Assign Webpage"

I think its more likely this was the change that resolved it.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
- Re: Scheduled reports only show the login page
  
  jest4kicks Jun 3, 2016 12:17 PM (in response to vehshya)
  
  I tried changing the action to "Save to disk", but I got the same output (PDF with just the login page).
  
  Maybe we're using different versions, but I don't see a "Properties to Execute" option in the Actions tab of the Report Schedule editor. It just lists "Actions to Execute," but there's no option listed for "Report Assigned".
  
  Edit: I found the section you were referring to. For me, it's under the Report Schedule editor's "Properties" tab.
  
  I tried changing the "Reports Assigned" to the URL of the desired report, but I'm still getting the same result.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Scheduled reports only show the login page
    
    vehshya Jun 3, 2016 12:47 PM (in response to jest4kicks)
    
    I replied below to another person, but it looks like this
    
    This screen is under the actions section
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Scheduled reports only show the login page
      
      jest4kicks Jun 3, 2016 1:19 PM (in response to vehshya)
      
      Yup, that's what I tried. No luck. Thanks for clarifying, though!
      
      Like Show 0 Likes(0)
      
      Actions
- Re: Scheduled reports only show the login page
  
  foonly May 9, 2017 9:24 AM (in response to vehshya)
  
  Our reports already had a save of a local copy, and we use the Admin user. But we still see the login page in the PDF after upgrading to NPM 12.1 on 2 out of 3 servers. On one server, re-running the Config Wizard or rebooting the server (we did both) fixed the problem. But the other one stubbornly refuses to yield to our ninja skills.
  
  To me, the fact that updating the report in some non-obvious way has a side effect that "fixes" the symptom points to a problem with the upgrade or wizard.
  
  =Foon=
  
  Like Show 0 Likes(0)
  
  Actions
Re: Scheduled reports only show the login page

laurin.beckhusen Jun 3, 2016 11:48 AM (in response to jest4kicks)

I had this issue yesterday with my html and PDF reports. Our NPM server is setup for ssl only access and windows authentication. I noticed that the url was referencing the non ssl link and I had the same issue, the PDF only displayed the log in page.

We discovered that in the database manager under "ReportJobs" the new report had a different Website ID ( 2 ) all the working reports had the value of 1.
I then checked the Websites value and noticed that 1 was my ssl site and 2 was my non ssl site.

I went back to the ReportJobs made sure the WebsiteID column was set to 1. Closed saved and re ran. Report is working, except now I get a new email message:

Unable to retrieve url: https://orion.address using HTML type https://orion.address

Solarwinds support is looking into that now.

Best,
L
Like Show 1 Likes(1)

Actions
- Re: Scheduled reports only show the login page
  
  vehshya Jun 3, 2016 11:58 AM (in response to laurin.beckhusen)
  
  That is what I think my issues was as well. We forced SSL and used a DNS entry to change the address.
  
  By doing the following, we were able to resolve the issue:
  
  Edit Report Schedule
  Actions
  Properties to Execute
  Change the Report Assigned as a "Assign Webpage"
  
  To find the address, just simply open up the report and copy the URL into step 4.
  
  Let me know if that works,
  ~Dylan
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Scheduled reports only show the login page
    
    laurin.beckhusen Jun 3, 2016 12:11 PM (in response to vehshya)
    
    Did you happen to check your DB values. Curious if its two similar, but different problems.
    
    Just curious
    1 of 1 people found this helpful
    
    Like Show 1 Likes(1)
    
    Actions
    - Re: Scheduled reports only show the login page
      
      laurin.beckhusen Jun 3, 2016 12:23 PM (in response to laurin.beckhusen)
      
      My apologies. I am using NPM 12 RC.
      
      Like Show 0 Likes(0)
      
      Actions
    - Re: Scheduled reports only show the login page
      
      vehshya Jun 3, 2016 12:41 PM (in response to laurin.beckhusen)
      
      I've only got one entry for websites (non SSL link), reportjobs and reportjoburls.
      
      Like Show 0 Likes(0)
      
      Actions
- Re: Scheduled reports only show the login page
  
  neomatrix1217 Jun 3, 2016 12:04 PM (in response to laurin.beckhusen)
  
  If you paste the URL that the email is sending in a browser what do you get and is the URL correct?
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Scheduled reports only show the login page
    
    vehshya Jun 3, 2016 12:46 PM (in response to neomatrix1217)
    
    I then receive and email with a PDF copy of the report.
    
    Like Show 0 Likes(0)
    
    Actions

Go to original post