Workflow email skipped yesterday

[Neal_MF_Harper]

Our scheduled email report has been running fine, but did not run yesterday, just tested and it ran… the audit log shows nothing for yesterday, as if the rule didn’t exist, strange.

Anyone else see this issue? Are there any notifications that can go out if emails reports are having problems?

Thank you!
Neal

[Phil]

I can investigate if you provide:

1. Account id
2. App name
3. Report name

[Neal_MF_Harper]

1. 44800
2. 0407ProShotlist-44800
3. Print Still Life End of Day Shots

Thanks Phil!

[Phil]

The report succeeded on 4/20 and 4/21.

When the Schedule Service tried to invoke the report on 4/22, it failed with a timeout.
That indicates that the AppSheet service was not able to initiate the report in time.
There is no record in Audit History for the Report on 4/22 because the Report was not invoked.
I am not sure why the timeout occurred.

I noticed one thing that may be a factor.
On 4/20 and 4/21 the report took about 4 seconds to run.
When you invoked the report from the Editor “Test” button on 4/22, the report took over 14 seconds.
Over 8 seconds of that time was computing a virtual column called “Merch Department and Categories”.

The report is scheduled to run again at 6:00 PM this evening.
Can you let me know if it runs successfully?

[Neal_MF_Harper]

Will do, thanks Phil, the VC you mentioned is not new. The ‘missing’ 4/22 report only contained 6 records when we typically have 30 to 80.

I appreciate your time, Sir!

[Neal_MF_Harper]

Ran correctly yesterday, thanks Phil.

[Phil]

Thanks for letting me know it worked today Neal.

Please let me know if it fails again and I will investigate.

[Neal_MF_Harper]

Hi Phil, hit another issue with this email report yesterday, did not run, I did change the report to run Mon-Friday yesterday rather than every day, not sure if that caused the issue. Stranger, the log shows a disabled report ran, but email was not received. Let me know your thoughts!

[Phil · Accepted solution]

Hi Neal,

The report failed to run yesterday due to a timeout.
I think the timeout is occurring because your report got invoked directly on the hour along with a lot of other reports. I probably need to make some changes to handle the flood of reports that occur directly on the hour.

In the interim, you can greatly improve your chances of success by moving the time your report runs.
Is it possible to run your report at a slightly different time? For example, how about running it 10 minutes before the hour or ten minutes after the hour.

[Neal_MF_Harper]

Thanks for the info, I will adjust the time, would 5:55 be enough adjustment to avoid rush hour?

[Phil]

Forgot to mention the ‘Disabled’ rule.

The rule ‘Print Still Life End of Day Shots FOR YESTERDAY’ was not run because it was ‘Disabled’.
You can verify this by opening the Audit History record and looking for ‘RuleSkipped: Rule is disabled.’

[Phil]

Yes, that would help.