Can you run the report from the reports menu without going through the schedule manager? Just click on the report and say "view report". If it doesn't run there you have an issue with the report setup not the scheduler.
I run similar reports on a monthly basis also. You have to create a schedule to run the report monthly on the 1st for the month. The way I have mine setup is after you create the schedule assign it to the report.
I have mine with the web link after I run the report manually.
You also have to have a user name that has an account to run the report. I have an account in Solarwinds for reporting with a password for this purpose. You enter this in the advanced settings at the bottom of the first page when you setup the schedule.
Thanks for the reply Marc.
So you're correct. That seems to be my issue, I'm unable to run the report right from the report tab. Strange though, I can run it from the stand alone app on the server itself. I've tried different browsers, all the same issue.
The error is pretty cryptic, any idea?
- System.Runtime.InteropServices.COMException (0x800A017F): Exception from HRESULT: 0x800A017F (CTL_E_SETNOTSUPPORTED) at C1Query80.C1QueryClass.set_Schema(String pVal) at SolarWinds.Orion.Web.Reporting.C1QueryWrapper..ctor() at SolarWinds.Orion.Web.Reporting.OrionReport.BuildQuery(String orderBy, String grouping, String filter) at SolarWinds.Orion.Web.Reporting.ReportRunner.WorkerProc()
That error message is above me. You might have to open a ticket with Solarwinds.