Troubleshooting data wizard counts and updates

Issue symptom

An item in the Status window shows as stuck at the Pending status and does not change to Complete, an error might have occurred during the update.

Issue scope

While monitoring the data wizard for a halted count or update

Resolution

If the count or update is halted or interrupted, check the errors and then follow the procedure to re-run the data wizard action. You can perform a new count instead of re-running a count. For an update, however, you must perform a re-run.

To check for errors

• DLD:Lock form—Search for a record with FormName01 = DLD:SYS:DataWizAction. If there is such record, it indicates either the process is still running, or a processing error is preventing this record from being deleted after the process has completed.
• CAI Events form—Search for records with App Interface Form = DLD:SYS:DataWizAction. The comments in the Return Message field indicate which error occurred.
• Filter log—Run the filter log to check for any errors.

To rerun the count or update

1. Clear the lock that indicates the data wizard is running:
   1. Open the DLD:Lock form.
   2. Search for a record where the Form Name01 field is set to DLD:SYS:DataWizAction.
   3. Delete the record.
2. Rerun the count or update:
   1. On the Data Wizard Console, click View Audit Log.
   2. Open the audit of the action that was halted or interrupted.
   3. Click Re-Run.
      The count or update resumes running from where it was halted or interrupted.