Row Information Spooling (RIS) Files

Use this page to identify and repair failed transactions by using the Row Information Spooling (RIS) files for Enterprise Replication (ER)

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

An RIS file is generated when a replicated transaction that has row scope defined fails to be applied to the target database because of a conflict, and the entire transaction fails. Each RIS file contains information about a single failed row. When you repair the transaction by using the RIS file, you repair the row that is recorded in the RIS 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: RIS files provide one way for you to repair data inconsistencies if replication fails and data is not synchronized. RIS files are useful for repairing a few transactions at a time, typically approximately 20. If you see many RIS 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 Row Information Spooling (RIS) Files page lists the RIS files and provides the ID, file name, creation time, size, and related ATS file, if any.

To repair the transactions, click the check box at the top of the column to select all the RIS files, and then click Repair. You can also select the check boxes for individual RIS files. However, if you do not repair all the available RIS 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 RIS file detail, click the RIS file name.
To view the detail for a related ATS file, click the ATS file name.

Row Information Spooling (RIS) File Detail

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

ID: The unique identifier for the RIS file.
Creation Time: The time that the RIS file was created.
Filename: The name of the RIS file.
Size (bytes): The size of the RIS 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.
Related ATS File: The related ATS file, if any.
Initial File Content: The first 10 lines of the RIS file. RIS files contain the same information as ATS files, plus the following additional information:
- Individual row errors
- Replication exceptions (such as when a row is converted by ER from insert to update, or from update to insert, and so on)
- Special SPL routine return codes, as defined by the application (if an SPL routine is called to resolve a conflict)

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

RIS Repair Task

This page displays the information about the repair task.

Before you begin the repair task, the page displays the RIS 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 RIS file details, click the name of the file.
To begin the repair task, click Repair.

After you begin the repair task, the RIS 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 RIS 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.