Oracle GoldenGate Error Messages

OGG-00823

A key column on the after image was not present in the before image on table {0} column index {1,number,0} This is because column(s) were added to the table after it was originally created. This is a known issue with DB2 LUW that can only be addressed by IBM.


Cause

Columns were added to the specified table, so the after image contains a column that was not present in the before image that is used by Oracle GoldenGate for comparison purposes.


Action

Exclude this table from the Oracle GoldenGate configuration, stop user activity on it, and then resynchronize it with the target table. Add it back to the Oracle GoldenGate configuration, and then restart the processes.