Return
-
Title
Out of Sync with supplemental logging for Pk/UI enabled -
Description
Table keeps getting out of sync. Supplemental logging for PK/UI is enabled on source and errorlog.sql shows the where clause for one of the key column value has the data from another column.
-
Cause
capture fails to calculate the column index for the column in the supplemental logging data if the row-piece contains F bit, i.e. migrated row.
à -
Resolution
STATUS:
This issue will be fixed in future release of SharePlex 7.x
-
Defect ID
ST84901 -
Additional Information
The requirements for this problem to happen:
1. PK/UI supplemental logging.
2. Update on the first row piece of a migrated row.
3. The key columns are on columns other than the first column.
4. The updated columns should not be on the columns that come before the first key column.