4 Replies Latest reply: May 16, 2012 3:11 PM by 934646 RSS

    Re:replicat abended while using update statement

    934646
      Hi all!!

      My source is win 2003 server 10gR2 goldengate 11.1.1.1.2
      target 2008 server 11gR2 goldenaget 11.1.1.1.2

      on source manager started, extract started
      on target manager started, replicat started

      everything is fine, (here i am testing online change synchronization)

      but then when i gave update statement replicat abended, when i cheked the error log, the following is the error

      2012-05-16 13:13:04 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, REP1.prm: No unique key is defined for table SAMPLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
      2012-05-16 13:13:04 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'SAM.SAMPLE', Database error 1403 ().
      2012-05-16 13:13:04 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 994 in seqno 0.
      2012-05-16 13:13:04 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping SAM.SAMPLE to SAM.SAMPLE.
      2012-05-16 13:13:04 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 994 in seqno 0.
      2012-05-16 13:13:04 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from SAM.SAMPLE to SAM.SAMPLE.
      2012-05-16 13:13:04 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP1.prm: PROCESS ABENDING.

      can any tell how to resolve it?

      there are no primary keys,indexes,triggers on the source and traget table and both schemas and table structure is same.