Return
-
Title
What to check when out of sync errors are being encountered in Shareplex. -
Description
Shareplex post process is logging SQL in Shareplex var dir/log/*errlog.sql and event_log shows Shareplex detecting out of sync (OOS).
This is typically due to these:
INSERT - unique constraint violation, record with the same key already exist on target
UPDATE - pre-image of the column being changed does not match whats on target, or the record does not exist on target
DELETE - the record Shareplex tries to delete is already deleted on target
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.