No data found on replicat process ( ORA-1403 )
edited Sep 28, 2012 4:00AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
after doing initial load. I am starting replicat process.
start replicat rep, aftercsn 1089667
The aftercsn was the source db csn number used during expdp.
replicate aborts
2012-09-25 14:56:35 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2012-09-25 14:56:35 INFO OGG-01373 Oracle GoldenGate Delivery for Oracle, rep1.prm: User requested start after CSN 1089667.
2012-09-25 14:56:35 INFO OGG-01374 Oracle GoldenGate Delivery for Oracle, rep1.prm: Transaction delivery commencing at position Seqno 0, RBA 1282, Transaction ID 8.26.841, CSN 1089688, 0 transaction(s) skipped.
2012-09-25 14:56:35 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on 'HR.EMPLOYEES', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "HR"."EMPLOYEES" SET "SALARY" = :a1 WHERE "EMPLOYEE_ID" = :b0>).
start replicat rep, aftercsn 1089667
The aftercsn was the source db csn number used during expdp.
replicate aborts
2012-09-25 14:56:35 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2012-09-25 14:56:35 INFO OGG-01373 Oracle GoldenGate Delivery for Oracle, rep1.prm: User requested start after CSN 1089667.
2012-09-25 14:56:35 INFO OGG-01374 Oracle GoldenGate Delivery for Oracle, rep1.prm: Transaction delivery commencing at position Seqno 0, RBA 1282, Transaction ID 8.26.841, CSN 1089688, 0 transaction(s) skipped.
2012-09-25 14:56:35 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rep1.prm: Aborted grouped transaction on 'HR.EMPLOYEES', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "HR"."EMPLOYEES" SET "SALARY" = :a1 WHERE "EMPLOYEE_ID" = :b0>).
0