Restore Process Report

The Restore Process generates a Restore Process Report that provides general information and statistics about the Restore Process.

The following is a sample:

Restore Process Report. The contents of the Restore Process Report are explained as follows.

The Restore Process Report displays the following information:

Process Summary

Summarizes the number of Archive Files processed, the number of Subset Extract Files created, and the number of files successfully restored.

File Details

Displays the status, number of errors and warnings, and the name of each Archive File processed in the Restore Request. Summarizes the number of Archive Files processed, the number of Subset Extract Files created, and the number of files restored.

Possible status messages are:

Restore Complete
The Restore Process for the Archive File (Insert or Load) has completed without errors.
Restore Failed
The Restore Process for the Archive File (Insert or Load) encountered an error.
Row Selection Complete
The Subset Extract File was successfully completed. The Restore Process was not attempted. (Prior Restore errors could cause this condition.)
Row Selection Failed
The Subset Extract File was not created due to errors encountered.
Aborted
The Restore Process (Insert/Load) was cancelled by the user.

Row Selection Process

The Row Selection Process section of the Restore Process Report contains information on each Subset Extract File that was created.

The details included in the Row Selection Process section include the following:

  • Name of the Server.
  • Name of the Archive File.
  • Name of the generated Subset Extract File.
  • User IDs of the user.
  • Date and time the subset Extract Process started.
  • Date and time the subset Extract Process completed.
  • The elapsed time.
  • Process status that lists any errors or warnings that occur during processing.

Process Summary

Statistics are provided for the data copied to the Subset Extract File during the subset Extract Process:

  • Number of Tables Processed.
  • Number of Rows Extracted.
  • Number of Rows with Errors.
  • Number of First Pass Table Rows.

Row Details

Statistics are provided for the rows copied to the Subset Extract File from each table in the Archive File:

  • Number of rows extracted from each table.
  • Number of failed rows for each table.
  • Names of tables used in the subset Extract Process. The tables are listed in the same order as in the Access Definition.

Insert (or Load) Process

The Insert Process (or Load Process) section of the Restore Process Report contains information on each Insert or Load Process that was performed during the Restore Process.

The information in this section includes the following:

  • Name of the Request (or Untitled if you did not save the request).
  • Name of the Server.
  • Name of the Source File.
  • Name of the generated Control File.
  • Name of the Table Map (or Local).
  • The Restore Row Limit (or None if no row limit was specified).
  • Indicator (Skipped or Processed) for processing file attachments.
  • User IDs of the user.
  • Date and time the process started.
  • Date and time the process completed.
  • The elapsed time.
  • Indicator that the Control File was retained or deleted.
  • Process status that lists any errors or warnings that occur during processing.

Process Summary

Statistics for the data restored are provided:

  • Total number of Tables Processed.
  • Total number of Rows Restored.
  • Total number of Rows with Errors.
  • Total number of Rows Skipped (a row may be skipped as the result of the On Error Option selected for an Archive Action).
  • Subset Extract File status (retained or deleted).

Row Details

Information is provided for each table:

  • Number of rows inserted.
  • Number of rows updated.
  • Number of failed rows.
  • Number of rows skipped.
  • Names of tables used in the Restore Process.

Errors

If any errors occur during processing, a list of the errors is provided. Review the list of errors that caused processing to stop. For example, an internal error condition exists when the process exceeds the discard row limit or if you are not authorized to access a particular database table.

Save the Report

To save the report to a file, click File > Save As to open the Windows Save dialog.

Print the Report

To print the report, click File > Print to open the Windows Print dialog.

Redisplay the Report

If you need to refer to the report after closing it, click File > Redisplay Results > Current to redisplay the report from the last Restore Process run, or click File > Redisplay Results > All to display a list of all retained Restore Process Reports.

For details about retaining process reports, see the Common Elements Manual .

Note: Once the Restore Process is complete, you can also review an abridged version of the process report focusing on a specific Archive File. In the Restore Request Editor, right-click an Archive File name and then click Browse > Results.