Troubleshooting scheduled report issues
This article guides you through the process of troubleshooting errors in scheduled reports. It provides steps to help you eliminate common causes for your problem by verifying that the configuration of your networking is correct.
Symptoms may include the following:
- Scheduled report fails to run.
- Not all data appears in the scheduled report.
- Cannot schedule a report.
- Scheduled report is empty.
- Scheduled report fails to run at a specified time
- Scheduled reports are not delivered to user
Review the email log to confirm that an email has been sent.
To review the email log:
- Navigate to System logs > Emails. Search for the email that was sent out.
- Navigate to Scheduled reports.
- Find the report mentioned.
- Right-click the header and click Show XML.
- Find the active tag and make sure it is set to true.
- Confirm that the report is being sent to the correct users. To do this, go into the scheduled report and see who this report is being sent to. For example, Users and groups.
- Verify that the proper schedule conditions are set. To verify that the proper conditions are set, go into the scheduled report, and check the RUN time. These are the following options: daily, weekly, monthly, periodically, Once, or on demand.
- If the conditional flag has been set, check the conditions in the script to make sure the script does not have any issues. (Refer to the person who wrote the script if this is customary.)
- Verify that the run as user has the correct permissions. Scheduled Reports are distributed via email. Scheduled reports created by an individual whose user account is deactivated might not display any data. To ensure that the desired data is displayed, an active user must recreate the scheduled report.
- Confirm that recreating the scheduled report does not resolve the issue. Try recreating the report.
- Determine if there are null pointer exceptions in the log files. Check log files, search for NullPointer exceptions.
- Refer to the following documentation for the types of reports that can be scheduled, and the roles required, Automate report distribution
- To schedule a multi-level and send as pdf have this plugin enabled - Webkit HTML to PDF (com.snc.whtp) plugin.
- If domain separation is enabled, make sure the user trying to schedule the report and the report are in the same domain
- If scheduled report is not executing in the right time zone, check whether the run_as field is empty or populated with a user name:
- If the run_as field is empty, the report runs in the system time zone.
- if the run_as field is populated with a user name, the report runs in the time zone of the user.
Note: To manually specify the time zone, configure the form to add the Run As tz field to the Scheduled Report form.
- If scheduled reports are not delivered to user, turn on the Allow Notifications and Primary email switch by following the instructions here. You can also change the Schedule Report definition to send directly to the user's email, which does not depend on any user profile setting.
For more information, see the documentation topic Scheduled jobs.
If not all the data appears in the scheduled report:
- The main cause of this is due to ACLs that have not been set up. Verify that a user can access the data that is in the table. If they can see the data that is in the table, its most likely not an ACL issue.
- Check to make sure that the run as user is set to active. If the user is not active in in the instance, this will cause problems.
- Make sure the data is not dynamic. If the data is changing, and the scheduled report runs, the data will be different or won't be available.