Oracle Golden Gate Replication with conflict resolution produces the error: WARNING OGG-01923 Confli
We seem to have run into an issue with OGG 11.2.0.5 in a multimaster configuration. We have four servers A, B, C, D. An insert is created at A, an update is performed at B and the update gets to D before the insert. CDR tries to do the update, determines that the row does not exist, converts the update to an insert. Meanwhile, the insert comes in and is applied to the database. When CDR tries to complete its insert, it fails with SQL error 1, ABENDS and gives the error message above.
Has anyone seen this before? Could this error be caused by any other condition? Possible workarounds include REPERROR statemnts, but OGG does not have one for this condition. My thought is that when OGG encounters the SQL 1 error, on its update->insert conversion, it should roll back and execute the INSERTROWEXISTS condition to maintain performance. Does anyone think of this as a bug?