replication is not happening in DB although in GG stats showing the UPDATE counter increased
Hi,
- I have updated a non primary key column in source . Committed.
- Stats from GG UI shows an increase in no of updates at both in extract as well as in apply.
- But problem is actually that record is not being updated in the Target DB.
- Supplimental log has been set in DB at db and schema level. Table is having big no of column so have not set the supplimental for all columns.
- I have used HANDLECOLLISIONS to control data collision.
- Normal insert/updates/deletes working fine.
- It's not updating in the scenario, when I am updating the record in the source but the same record is not existing in the target DB. Ideally it should have converted the update as insert , since I have used the HANDLECOLLISIONS parameter.
0