Integrated Replicat Resolved Both Table & Schema Map And Caused Duplicate Records Into Target Table (Doc ID 3018196.1)

Last updated on JUNE 19, 2024

Applies to:

Symptoms

OGG is configured to extract data from Sybase and then replicat to Oracle database.The repilcat process is set as below:

Both statements are getting resolved and causing duplicate data in target.

After inserting a single record in <Source_schema_name>.oggtest in source database, OGG replicat the record and insert two records in the target table

Source:

insert into oggtest(n,c) values (1,'A');

n c
------------------
1 A

Target:

It shows the table oggtest
SQL> select * from <schema_name>.OGGTEST;

N C

------------------

1 A
1 A    <---Duplicate record

Issue persist in below Goldengate versions

Goldengate 19.1.0.0.221018 (Parallel Replicat) --> not working
Goldengate 19.1.0.0.221018 (Integrated Replicat) --> not working

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.