1 Reply Latest reply: Mar 5, 2012 8:40 AM by Srini Chavali-Oracle RSS

    Sequence Error During Golden Gate Replication!

    misterimran
      Dear All,

      I am replicating 2 databases one way, from production to standby using golden gate.
      Both databases are 11gR2 and on Linux.

      Replication runs smooth for couple of days and then ends up with this error:

      ERROR OGG-01296 Error mapping from ETISLBILLING.PAR_TBLPARNODEIDENTI to ETISLBILLING.PAR_TBLPARNODEIDENTI.
      Parent Ket Not Found ETISLBILLING.FK_PARTNERNODE_IDENT

      Trigger : ETISLBILLING.TRG_PAR_TBLPARTNERNODE Sequence : SEQ_PAR_TblPartnerIdenti

      ORA-20000: Sequence value cannot be changed.

      Main error is that value of sequence that is executed during the after insert trigger, does not change and trigger raise error hence the replication process is stopped.

      I am just worried that the same triggers and sequences are executed successfully on production database and standby database has is exactly the same as production.

      Is there some special treatment for sequences?

      Kindly help on this.

      Regards, Imran