Troubleshooting data validations

The Scheduler Data Manager application validates the data that you include in your schedules and work lists. When errors are found in the data that is included, you can make corrections or exclusions as needed.

You use the Scheduler Data Manager application to test your data for scheduling and assignment best practices. You can check your data before you view it in the graphical view, or at any time to catch and change any potential problems. The application looks at the key data components of the schedule or work list, specifically the following items:
  • Calendar
  • Queries
  • Work
  • Dependencies
  • Assignments
  • Resources
Table 1. Example: Key indicators (partial list)
Tab Parameters
Calendar
  • Does the calendar cover the entire schedule?
  • Are there work periods for the shifts defined?
  • Are the shift patterns sequential and named?
Queries
  • Does the SQL clause affect performance?
  • Does the clause retrieve a reasonably sized data set?
Work
  • Do the work orders have defined durations?
  • Does non-interruptible work exceed the shift length?
  • Do work orders have work plans?
  • Is work prioritized?
  • Do work plans have resource quantities that exceed availability?
Dependencies
  • Are the precedence relationships between work records and tasks non-circular?
  • Are they affected by work status or actual dates?
Resources
  • Are crafts, crews, and rotating tools available in a sufficient quantity to be able to schedule work at a specific point in the schedule?

For each category, click Validate, review the data rows in the table, and review any errors or warnings. In many cases you can fix the issue in the table, which updates the associated records and improves your schedule.

For larger or rolling schedules, consider running validation through a scheduled a cron task, so you can review the results regularly.