Integrated Replicat
Hello
I noticed something interesting with an integrated replicat I have.
Environment:
OGG 12.2.0.1.1
DB - Oracle 12.1.0.2
Platform : EXADATA with Linus as OS
Issue:
I have integrated replicat running. Most tables have an additional column in the Target PK and have DML Handler Rules defined on them. The DML Handler Rules add the additional columns and assign values and also convert updates and deletes into inserts.
The replicat abended and when I checked the report, it had an unhandled error reported from the DML Handler User Procedure while replicating a delete and converting it into an insert.
The rpt file also reported that the replicat retried in direct mode. This failed with a no_data_found.