Data Server Errors

Data server errors, such as permission violations or duplicate keys, are logged in the Replication Server error log.

If you cannot correct the data server error, restart the Data Server Interface (DSI), requesting that the first transaction (the one causing the error) be skipped. Execute resume connection with the skip transaction option.

Warning!  Skipping transactions may cause replication inconsistencies.

If errors are caused by unique-key violations, use set autocorrection to turn automatic error correction on, before you resume the connection. These errors are likely to occur during nonatomic materialization. For more information about set autocorrection, see the Replication Server Reference Manual.

If using set autocorrection does not work, use the skip transaction option of the resume connection command. This option skips the materializing or dematerializing transaction altogether. If the problem occurred during subscription materialization, drop the subscription and create it again in a way that avoids the same problem.

Related concepts
Subscription Problems