RE: GoldenGate Missing/Skipping Transactions

Hi Seth,

I’m new to GoldenGate also. We ran into a similar issue with 1403 on our replicat. Ended up being the primary key index was not created with UNIQUE keyword. I think we found some info in the discard file that led us to looking at the index.
-Leo

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Seth Miller Sent: Wednesday, April 8, 2020 2:32 PM
To: Bobby Curtis <curtisbl_at_gmail.com> Cc: Oracle-L Freelists <oracle-l_at_freelists.org> Subject: Re: GoldenGate Missing/Skipping Transactions

Bobby,

Yes, this is the Marketplace image. The load is pretty light but tends to be bursty.

ggserr.log shows the 1403 errors but doesn't show anything about the skipped insert.

I only added COMMIT_SERIALIZATION FULL and BATCHSQL_MODE SEQUENTIAL after identifying this issue hoping it was an transaction ordering issue but they don't seem to make any difference.

Seth

On Wed, Apr 8, 2020 at 1:15 PM Bobby Curtis <curtisbl_at_gmail.com<mailto:curtisbl_at_gmail.com>> wrote: 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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>" <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Seth Miller <sethmiller.sm_at_gmail.com<mailto:sethmiller.sm_at_gmail.com>> Reply-To: "sethmiller.sm_at_gmail.com<mailto:sethmiller.sm_at_gmail.com>" <sethmiller.sm_at_gmail.com<mailto:sethmiller.sm_at_gmail.com>> Date: Wednesday, April 8, 2020 at 1:49 PM To: Oracle-L Freelists <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> 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.*;

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

This e-mail, attachments included, is confidential. It is intended solely for the addressees. If you are not an intended recipient, any use, copy or diffusion, even partial of this message is prohibited. Please delete it and notify the sender immediately. Since the integrity of this message cannot be guaranteed on the Internet, SODEXO cannot therefore be considered liable for its content.

Ce message, pieces jointes incluses, est confidentiel. Il est etabli a l'attention exclusive de ses destinataires. Si vous n'etes pas un destinataire, toute utilisation, copie ou diffusion, meme partielle de ce message est interdite. Merci de le detruire et d'en avertir immediatement l'expediteur. L'integrite de ce message ne pouvant etre garantie sur Internet, SODEXO ne peut etre tenu responsable de son contenu.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 13 2020 - 19:26:12 CEST