Scheduled Report Comes out Blank... sometimes

[Droid101]

So, I have a very simple report, which shoots out an email with the report in excel format attached, each morning at 5AM.

This report is just a list of open incidents assigned to specific groups. There are always at least 50-100 records in this report, always.

Every once in a while (say, twice a week), this report shoots out blank. When I go into the scheduled report a couple of hours later and hit "Execute now" it comes out and has the correct info in it.

Why would this happen?

[gaidem]

There is not enough information to be able to troubleshoot this. However, you can choose to omit the schedule if there are no records in the report. Although, it sounds like you're concerned that there are records, they're just not being included.

[Droid101]

Yeah, there definitely are records, and the report is coming out blank. But, when I do "execute now" five minutes after the scheduled one runs, the records are in the report just fine. It's intermittent, meaning some days it comes out and works correctly with all the records without me having to re-run. Some days, it's blank.

Because of how random it is, I think I might have to open an incident with Service-now. Just thought maybe someone out there has seen this in the past.

[gaidem]

Definitely open an HI ticket.

Best of luck, and please post what you hear back.

[chadcrawford]

I came upon this thread after experiencing a similar situation with scheduled reports. Unlike Droid101's intermittent issue however, we had a scheduled report that worked one day, but started spitting out blank from then on.

Opened a HI incident and pretty quickly learned the problem.

Turns out there's a "Run as" field on the Scheduled Reports form, that in our instance wasn't being displayed. That field was populated with a user who had been disabled.

Replaced the disabled user with myself. Problem solved.