Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

goldengate update command

934646May 23 2012 — edited May 24 2012
Hi all
I am going migration from 2003 server(10gR2) to 2008 server(11gR2) with goldengate 11.1.1.1.2
while i am trying to update a row it is not replicating on the target. At first it gave me an error but later when i tried by giving alter replicat begin now command it worked, but again when i give the update command it is not even giving me an error and replicat is not abended , no replication

My discard file looks like this:
Oracle GoldenGate Delivery for Oracle process started, group REP1 discard file opened: 2012-05-23 11:34:49

Current time: 2012-05-23 11:36:53


Operation failed at seqno 0 rba 2614
Discarding record on action DISCARD on error 1403
Problem replicating SAM.SAMPLE to SAM.SAMPLE
Record not found
Mapping problem with compressed key update record (target format)...
*
ID = 1
NAME = NULL
ID = 2
NAME = NULL
*

my replicat file:
REPLICAT REP1
USERID ggt_sys PASSWORD ggt_sys
DISCARDFILE c:/goldengate/dirdat/rep1.dsc, append, megabytes 10
REPERROR default, discard
ASSUMETARGETDEFS
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
MAP SAM.*, TARGET SAM.*;

I tried by cleaning the tables and by recreating the parameters. Source and table structure is same. Insert,create, delete are working fine..

thanks in advance..
This post has been answered by amardeep.sidhu on May 24 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2012
Added on May 23 2012
12 comments
5,776 views