Report Scheduler - "Error Processing Job"

D_W_K

I am trying to email a web page which will open and create an Excel spreadsheet of the results.  I've been able to do this manually in emails, by sending the url to colleagues to test with no problems.

However, in the report scheduler, the job will not run - I get an error message saying "Error processing job", which then says that "the content type was not valid in this context".  I think I've narrowed it down to the attempt to have it in Excel format, because if I remove "&dataformat=excel" from the end of the URL in the job then it works perfectly.

Can anybody advise?

mharvey

Since the URL is basically trying to export and save to excel, this becomes a function that the report scheduler isn't set to handle.  The scheduler is going to run the task to try to basically pull a screen capture of the report, or web URL at the time it is set to run.  While inside the scheduler you can tell it to export to pdf, what you're trying to do would be the same as having the scheduler use the export to pdf button on the website, it's just not designed for that.  The same applies with the report scheduler.  To get it to work, you would have to only email out the link to someone, then it would do a local call to excel to pull the data from the link.  This is not what the report scheduler is trying to do, it's trying to pull and format an excel sheet for the report, which it won't be able to do on the server.

Regards,

Matthew Harvey

Loop1 Systems