Scheduled Report randomly times out.

Summary:

Hi,

We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, this runs nightly and randomly fails a couple of times a week.

Content (please ensure you mask any confidential information):

We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, this report has been scheduled to run daily and it has been working without issue for 7+ years but suddenly it is randomly timing out. It works 2 or 3 days, then if fails, then it works again.