Tuesday, November 12, 2013

ERROR OGG-01444 Oracle GoldenGate Delivery for Oracle, RPCS03.prm: Error in replicating sequence value [ORA-20783:

One of the group started abending with sequence failure as you see below:

2013-11-11 14:43:21  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, RPCS03.prm:  Aborted grouped transaction on 'SCHEMA.SEQUENCE_NAME', Database error 20783 ().
2013-11-11 14:43:21  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, RPCS03.prm:  Repositioning to rba 1850715874 in seqno 15.
2013-11-11 14:43:22  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, RPCS03.prm:  SQL error 20783 mapping SCHEMA.SEQUENCE_NAME to SCHEMA.SEQUENCE_NAME.
2013-11-11 14:43:22  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, RPCS03.prm:  Repositioning to rba 1850730331 in seqno 15.
2013-11-11 14:43:22  ERROR   OGG-01444  Oracle GoldenGate Delivery for Oracle, RPCS03.prm:  Error in replicating sequence value [ORA-20783:
ORA-08004: sequence SEQUENCE_NAME.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "GGADMIN.REPLICATESEQUENCE", line 418
ORA-06512: at line 1 SQL BEGIN ggadmin .replicateSequence (TO_NUMBER(91900), TO_NUMBER(20), TO_NUMBER(1), 'SCHEMA', TO_NUMBER(10000), 'SEQUENCE_NAME', UPPER('ggadmin'), TO_NUMBER(2), TO_NUMBER (0), ''); END;].
2013-11-11 14:43:22  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, RPCS03.prm:  PROCESS ABENDING.

Compared this sequence at the source and target and I see the maxvalue is set to same in Source and Target.
BTW, flush sequence is not an issue as this was already taken care in the beginning of group setup.

Only thing I can find so far on this kind of issue is that it might be a bug that I am hitting (BUG:17300028 - REPLICAT ABENDS WITH ORA-20783 WHILE REPLICATING SEQUENCE). 

Anyways, I took a chance with a workaround that I thought will work to by pass this issue after making sure that this sequence is not used in the database anywhere and knowing very well that maxvalue for this Sequence is set at Source and even if it is used it wont be crossing that maxvalue.

So, what i did is recreate that sequence at Target with higher maxvalue than it is defined and started replicat and its running fine now.

No comments:

Post a Comment