Syniti Replicateis designed to recover from most errors in an automated and efficient manner so that you do not lose data or have unusual delays.
However, on occasion during continuous mirroring, you may encounter an error that requires a complete refresh of the target table. Before taking this step, verify that the errors you have observed in the log apply to the current replication and replication settings:
Remove the log file. (You might want to copy it to a different location so that you can use it for comparison later.)
Check the log to see if the error(s) occur in the most recent replication.
Depending on the error, you may need to change the source tables to avoid the errors, then do an Initial Refresh of the target tables to match the modified source tables:
In your database environment, make changes in source tables as necessary to prevent further errors from occurring.
In the Management Center, select the replication.
From the right mouse button menu, choose Replication Properties.
On the General tab, click Mapping.
Check the mapping between source and target fields to see that this is not the cause of replication errors. For example, are source and target field data types compatible?
On the Scheduler tab, check Execute Initial Refresh.
In the Start Time field, click Now to set the execution time.
The refresh replication starts at the last transaction ID in the log and performs a truncation(removal) of the target table, then a complete replication of the source table. Subsequent mirroring operations use the transaction ID stored at the end of the refresh replication