Seth,
From your description it sounds like you are using the Marketplace image. How
heavy is the load on the replicat? You might be hitting an internal timer
issues.
What is the ggserr.log reporting?
Have you tried removing the BATCHSQL_MODE? The Integrated process typically
don’t perform well with the BATCHSQL_MODE from past experience.
Let me know how it turns out or if we need more discussion.
Thanks
Bobby
From: "oracle-l-bounce@xxxxxxxxxxxxx" <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Seth Miller <sethmiller.sm@xxxxxxxxx>
Reply-To: "sethmiller.sm@xxxxxxxxx" <sethmiller.sm@xxxxxxxxx>
Date: Wednesday, April 8, 2020 at 1:49 PM
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: GoldenGate Missing/Skipping Transactions
I am running GoldenGate Microservices 19.1.0.0.4 in OCI. The source is Oracle
SE 12.1.0.2. The target is Oracle EE 18.0 in OCI. I am using a single trail to
write to/read from.
I am replicating four schemas with no special mapping or transformations. Every
day or so but not at a specific time, the replicat will abend on an update with
a 1403 No Data Found. Looking at the trail through logdump, I can clearly see
the insert record before the update but it was apparently not executed. If I
set the replicat back to the RBA of the insert record it will not run it unless
I include NOFILTERDUPTRANSACTIONS when starting the replicat. Is there a
parameter or a default setting that would cause the replicat to skip these
inserts? Is there a setting to log skipped transactions so I can tell if these
are being skipped intentionally?
Here is the parameter file
replicat RPRD
useridalias xxx
DISCARDFILE discard_RPRD.txt, APPEND, MEGABYTES 1024
DBOPTIONS INTEGRATEDPARAMS(COMMIT_SERIALIZATION FULL, BATCHSQL_MODE SEQUENTIAL)
DDL INCLUDE ALL
DDLOPTIONS REPORT
DDLERROR DEFAULT DISCARD
Map SCHEMA_A.* Target SCHEMA_A.*;
Map SCHEMA_B.* Target SCHEMA_B.*;
Map SCHEMA_C.* Target SCHEMA_C.*;
Map SCHEMA_D.* Target SCHEMA_D.*;
MapExclude SCHEMA_A.*_STG;
The only thing I can figure at this point is that I am hitting a bug but an
exhaustive search hasn't revealed anything.
Seth
