GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Oracle Golden Gate - ERROR: duplicate key value violates unique constraint "checkpoints_rep1_pkey"

in GoldenGate, Streams and Distributed Database (MOSC) 14 commentsAnswered

Hi All,

We are new to Oracle Golden Gate and our microservice based setup involves data migration and real time ETL from source SQL server databases to an intermediate PostgreSQL (AWS Aurora) and then from intermediate to target PostgreSQL (AWS Aurora). The OGG version is 23.8.0.25.04.
When we are testing moving data from source to intermediate and to target, the extract and replicat between source and intermediate work correctly. The extract from intermediate also picks up changes correctly, but the replicat on target only works on few records before failing with below errors (viewed from OGG checkpoint table). When we click restart on that replicat, it again works through few records before errors and goes to ABENDED state.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center