Afternoon all,
I have a couple scheduled reports, out of the 40 or so that run daily, that sometimes produce the following report
And then when it is re-run, through the scheduler, I get the following.
Any ideas would be much appreciated.
Date
Votes
1 comment
-
CascadiaDataworks Usually two reasons for this. First is a time out issue. For some reason, the scheduler can't access the data in a reasonable time and then ultimately times out and "finishes" the report.
Usually, there is one specific call that is causing this so you may want to review your report for best practices or review the report with a consultant to look for inefficiencies or issues.
Another issue could be that the scheduler is trying to run the report when something is happening with the database, either a backup, heavy activity, or a rebuild.
Please sign in to leave a comment.