Recover from a Broken Sync Service | Teradata Data Mover - 17.11 - Use Case: Recover from a Broken Synchronization Service - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

When data sent to the standby server cannot be inserted, deleted, or modified successfully, the synchronization service is not working correctly due to either a bad foreign key issue or a duplicate primary key. Perform the following if the synchronization service is not working as expected:

  1. Drop this standby server from the synchronization service by following the steps in Use Case: Drop One Standby Server from the Synchronization Service.
  2. Add the server back by following the steps in Use Case: Add an Extra Standby Server to an Existing Active Server.