Scheduled Report No Longer Working

[jmiskey]

We have a Daily Scheduled Report that emails a team a set of three Excel files, which has been working fine for years.  All of a sudden today, it sent out three PDF files instead of the usual Excel files, and if you try to open them, you get the message "The sender does not have access to this report".

I think I may have an idea why this started happening, but do not know how to fix it, and my searches have been fruitless thus far.  Our manager, the person who stood up most of our ServiceNow environments, terminated employment yesterday.  So I am thinking maybe the report is somehow connected to him, and the fact that his User record is no longer active may be causing the issue.  If I open one of the underlying reports that is being sent, I can see it was created by some OTHER user though (who is still active). 

So I am not sure where I need to go make updates to allow this to work properly again.  Is there some kind of "Run as user" setting for Scheduled Reports that needs to be updated somewhere?

Thanks

[jmiskey · Accepted solution]

I found it.  It is under "Scheduled Email of Reports" and the field is "Run as".  It is not shown in the default view of the records, so you either need to add it to the List View or the Form View in order to see it and update it.

[Mohith Devatte]

hello @jmiskey Change run as user to some active user in the instance 

also make sure the recipients of the report has access to that report .

if not share the report with them accordingly and then try to execute the job 

Hope this helps 

Mark the answer correct if this helps you 

Thanks

[servicenow14710]

Hello @jmiskey : This post will be my solution which i am facing . can you please let me know what might the issue as -

we have a monthly  Scheduled Report that emails an Excel file which contains all the approvers,  it worked till last month it has generated record for jan month which is sent on feb  but it couldnt genreate the records of feb month , it sent out aPDF files instead of the Excel file, and if you try to open them, you get the message "The sender does not have access to this report".  can you please suggest /provide information as why the excel sheet is nt been generated . 

I searched run as with that user for whom email has sent , in the list it is showing name empty records. updated in each monthwe have a monthly  Scheduled Report that emails an Excel file which contains all the approvers,  it worked till last month it has generated record for jan month which is sent on feb  but it couldnt genreate the records of feb month , it sent out aPDF files instead of the Excel file, and if you try to open them, you get the message "The sender does not have access to this report".  can you please suggest /provide information as why the excel sheet is nt been generated . Any help is appreciated thanks!

[jmiskey]

Did you try my solution?

Setting the "Run As" user to some active user who has the proper permissions?