Extract puts junk value for sequence increment value. (Doc ID 2134081.1)

Last updated on MAY 04, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.28 and later
Information in this document applies to any platform.

Symptoms

Replicat abends with error on a sequence replication:

ERROR OGG-01444 Oracle GoldenGate Delivery for Oracle, rep.prm: Error in replicating sequence value [Error converting sequence increment to 64 bit. [ÿÿµ0BBB(]].

with logdump, the related record is:

After Image: Partition 4 G s
0000 000b 0000 0007 4747 5f54 4553 5400 0100 1100 | ........GG_TEST.....
0000 0d47 475f 5445 5354 5f53 4551 5f31 0002 0007 | ...GG_TEST_SEQ_1....
0000 0003 3134 3200 0300 0c00 0000 08ff ffab 5042 | ....142...........PB
4242 28 | BB(

the right record should be:

After Image: Partition 4 G s
0000 000b 0000 0007 4747 5f54 4553 5400 0100 1100 | ........GG_TEST.....
0000 0d47 475f 5445 5354 5f53 4551 5f31 0002 0007 | ...GG_TEST_SEQ_1....
0000 0003 3134 3200 0300 0600 0000 0231 30 | ....142........10

The highlight shows the junk value:'PBBB(' at setUpdate for the sequence record, which should be '10'.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms