goldengate replicat abends with ORA-01403 when using comparecols on update KEYANDMOD, on delete all
Goldengate Version 12.2.0.1.170221
Oracle database 12.1.0.2, Exadata, 2-node RAC, EE
Replication is set up from source database to target using simple schema to schema mappings.
We use comparecols to validate target data is correct before changes are applied...
MAP SECURITY.*, TARGET SECURITY.*, comparecols (on update KEYANDMOD, on delete all)
Replication was working perfectly for some time.
After applying Apr 2018 PSU for the database last week and restarting replication it exhibits the following behaviour
When COMPARECOLS is left in place, Replicat abends on UPDATEs. An audit trail excerpt shows the failed update statement at the target is as follows; note the PK column ACT_ID has no value, hence the ORA-01403 error.
0