Recovering worksheet data

The application automatically creates a system lock on plan data when the application:

  • processes an action on data on the Worksheet
  • is waiting to run an Async task in the Job Scheduler that performs an action on data on the Worksheet

This system lock ensures data integrity. The application automatically removes the system lock when the corresponding action, such as saving changes to data edited on the Worksheet, is completed successfully. See System Locks.

In certain exceptional cases, such as a power failure, or if the database is full, the Async task is not completed. In this case, the application does not automatically remove the system lock. For example, if a power failure occurred when the Async task was running, the task may still have IN PROGRESS status.

The Async task may have Failure status if:

  • in the Job Scheduler, someone clicked Resume to resume running the job
  • someone restarted the Job Scheduler

This status can appear when the Job Scheduler does not know where to restart the Async task.

If a task that does not have a recurring schedule fails, it does not automatically run again.

If an Async task fails and a system lock is not automatically removed, see Removing a system lock manually.