How to find root cause on replicat abend with OGG-02544?
Product: Goldengate 19.20 for Oracle 19c, classic architecture, 1 extract and pump in Source, 1 replicat in Target, all integrated
Source and Target Databases are Oracle EE 19.20
Background:
Once a month we refresh a non-prod database from prod (using Solaris zfs snap from a local standby). After the zfs snap, we drop all the goldengate process and rebuild them, with a datapump export/import for the data. Related, we also run a data masking job that seems to be overlapping part of this process, but we thought we had accounted for that.
We occasionally get an "data not found" error, and we have been trying to track down where it comes from. We are not exactly sure how to go about this, so we are asking for help. The errors are a little cryptic because they reference the output of the data masking job and are the result of a trigger firing on data that does not appear to exist in the source.