GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate Automatic CDR not automatically resolving insert-insert conflict

edited Jan 22, 2020 8:50AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Greetings,

I've configured GoldenGate running Integrated mode for automatic CDR in a 3-way active-active  but when I generate a unique key conflict, the ORA-00001 (unique key violation) exception is always written out to my exception table and does not resolve the conflict by overwriting the row with the older timestamp. I then have one server with a different row than the others. Any suggestions for how to change my configuration to properly configure for auto CDR?  I'm not certain what else to try.  To test I execute DML inserts as shown below:

insert into MySchema.MyTable(A,B,C,D,E,F,G)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center