goldengate update command
934646May 23 2012 — edited May 24 2012Hi 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..