No question at this time
DBA Top 10
1 A. Kavsek 8100
2 M. Cadot 7800
3 B. Vroman 6600
4 T. Boles 5750
5 J. Schnackenberg 4100
6 P. Wisse 2900
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
8 M. Hidayathullah ... 1100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48365
Total active users1548
Act. users last 24h5
Act. users last hour0
Registered user hits last week350
Registered user hits last month1228
Go up

Issue in GG Replication - OGG-01296
Next thread: Case in Where Clause
Prev thread: Monthly Table Partition Export (datapump)

Message Score Author Date
Hi Team, Issue related to Golden Gate Replication...... Jalal B Mar 28, 2019, 16:17
This issue is fixed. A Check Constraint was missi...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Jalal B Apr 08, 2019, 02:56
Thanks for the feedback. Regards Michel ... Michel Cadot Apr 08, 2019, 07:18

Follow up by mail Click here


Subject: Issue in GG Replication - OGG-01296
Author: Jalal B, India
Date: Mar 28, 2019, 16:17, 28 days ago
Os info: linux
Oracle info: Oracle 12C, Golden Gate-11.2.0
Error info: ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, r1lacrpt.prm: Error mapping from lac.LOCATIONPRE to lac.LOCATIONPRE.
ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r1lacrpt.prm: PROCESS ABENDING.
Message: Hi Team,
Issue related to Golden Gate Replication.

We have a ongoing Schema level replication in Progress.
Today, 2 columns from one of the table were dropped and one column was again added with modification.
And, the ddl replication happened, and the 2 columns got removed, and one column got added in the target db.

After this, On performing Update on this table in Source db,
We get error as below.

ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, r1lacrpt.prm: Error mapping from lac.LOCATIONPRE to lac.LOCATIONPRE.
ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r1lacrpt.prm: PROCESS ABENDING.


When creating def file, and including it in replicat param file, it works.
If that is commented, it fails.
Since DDL Replication is also happening, i am not able to have both sourcedef file and ddl replication in replicat process, it says not compatible.


Trandata added to source db table.
PK constraint exits in both source and target.

It was a working process, but this error occured after dropping and adding a column to the table in source.

Any finger pointing/Clue will be helpful.

Thanks, Jalal
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Issue in GG Replication - OGG-01296
Author: Jalal B, India
Date: Apr 08, 2019, 02:56, 18 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: This issue is fixed.
A Check Constraint was missing in the Target DB, and on adding that, the issue resolved.

Thanks, Jalal
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Issue in GG Replication - OGG-01296
Author: Michel Cadot, France
Date: Apr 08, 2019, 07:18, 18 days ago
Message:
Thanks for the feedback.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here