ReportScheduler Doesn't Always Run and Report is Flawed
Thank you for taking the time to help with this item.
Here is some context:
1. ReportScheduler runs a report at 12:05 every night and outputs into a folder on the C Drive.
2. A Macro goes in that directory for the most recent item, renames it and sends it to a folder where it can be used elsewhere.
The problem is that the ReportScheduler doesnt run everyday. I end up with something like this: July 1st, July 2nd, July 3rd are the names of the reports but the data in each of these three reports is from July 1st.
I don't get an error when the ReportScheduler doesn't run.
I need it to run consistently. Anyone with the same error that was resolved?
Carissa Marie Galgano
Scheduling the reports is normally quite reliable. The most common cause for a report not running is that it isnt scheduled correctly.
- Check that the report is scheduled correctly
- Look in the scheduling structure for either a sucessfull run or failure. There will be a log object in the scheduling structure in both cases.
- If the report ran but failed, check the windows event log on the server that runs the report. Ensure that all extensions are installed properly and that Excel addins and macro security are properly configured. Log on as the service account and run the report manually.
- If the report suceeded, make sure its going to the right folder and that you're looking for it in the correct location.
- If the report didnt run, run it manually and check the log object. Check the schedule configuration again.
I would check this:
-Time synchronization in your system, check that servers and controllers are running with accurate timing.
-User/group configurations, be aware of that scheduler is a service (executed by system account). Make sure that this service can access your destination folder.
-Having said this, if you are using DataDirect make sure that the Excel add-in is accessible as well.
-Also if you are using redundant services, make sure that you are referring to the correct server folder.