Aborted Transaction Spooling (ATS) Files

Use this page to identify and repair failed transactions by using the Aborted Transaction Spooling (ATS) files.

Prerequisites: Create a directory to store the ATS files, enable ATS file generation on the Enterprise Replication (ER) server, and activate ATS file generation for the replicate.

An ATS file is generated when a replicated transaction fails to be applied to the target database because of a conflict and the entire transaction fails. When you repair the transaction by using the ATS file, you repair the rows associated with the transaction that is recorded in the ATS file. The repair task reconciles rows that failed to be applied:

If a row exists on the source database server, it is replicated again.
If a row does not exist on the source database server, but does exist on the target server, it is deleted from the target database server.

Tip: ATS files provide one way for you to repair data inconsistencies if replication fails and data is not synchronized. ATS files are useful for repairing a few transactions at a time, typically approximately 20. If you see many ATS files or continual generation, consider some of the alternatives for resynchronizing data among replication servers. For example, you can check and repair or synchronize replicates and replicate sets by using the Check or Sync actions on the Replicates or Replicate Sets page.

The Aborted Transaction Spooling (ATS) Files page lists the ATS files and provides the ID, file name, creation time, size, and number of related Row Information Spooling (RIS) files.

To repair the transactions, click the check box at the top of the column to select all the ATS files, and then click Repair. You can also select the check boxes for individual ATS files. However, if you do not repair all the available ATS files at the same time, some repair tasks might fail because of problems maintaining the relationships between the tables (referential integrity constraints).
To view the file detail, click the file name.

Aborted Transaction Spooling (ATS) File Detail

This page displays the following information for the selected ATS file:

ID: The unique identifier for the ATS file.
Creation Time: The time that the ATS file was created.
Filename: The name of the ATS file.
Size (bytes): The size of the ATS file.
Source Node: The ER node where the transaction originated.
Target Node: The target ER node.
Commit Time: The time that the transaction was committed on the source node.
Receive Time: The time that the target node received the transaction.
Corresponding RIS Files: The list of any related Row Information Spooling (RIS) files.
Initial File Content: The first 10 lines of the ATS file.

To repair a transaction by using the ATS file, click Select for Repair.

ATS Repair Task

This page displays the information about the repair task.

Before you begin the repair task, the page displays the ATS files that you selected for repair so that you can review them.

To remove a file from the repair task, clear the check box.
To review the ATS file details, click the name of the file.
To begin the repair task, click Repair.

After you begin the repair task, the ATS Repair Task Status shows the progress of the repair task. The table provides the following information for each task:

Status:
- Completed - repaired: The repair task is completed, and the data inconsistencies are repaired.
- Completed - with errors: : The repair task is completed, but errors occurred.
- Repairing: The repair task is in progress.
- Waiting: The repair task is waiting to start.
File Name: The name of the ATS file. To display the details of the task, click the file name in the list.

The Repair Task Details section displays the repair operations and the messages from the server about the repair task.