My Oracle Support Banner

Goldengate 12.2 Extraction On AS400 Failed With ERROR OGG-06602 (Doc ID 2632095.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.2.0.2.2 to 19.1.0.0.4 [Release 12.2 to 12.3]
Information in this document applies to any platform.

Goal

Qn1:We have upgraded Goldengate 12.1 to 12.2 couple of month back on AS400 and since then we had ran into an issue where we had to change the As400 journals sequence number to continues change mode.


So when the Sequence number is reaching the max value (which is 9,999,999,999) ..each time it is causing the database transactions on the journal to hung and our SA has to manually reset the Sequence number and we had to manually alter the extract to the new sequence.

We want to know how to handle this situation without causing an issue?
Also in 12.1 we never had to do this.
Please suggestion.


Extrace error message-

2019-08-11 08:08:04 ERROR OGG-06602 Journal Sequence Number out of order in single journal extract.
Journal: TL/QSQJRN. Current Journal Receiver: TL/QSQJRN6469. Current Journal Sequence Number: 1. Previous Journal Sequence Number: 14,340.
This is likely due to Journal Sequence Number has been reset for the journal TL/QSQJRN.
Review this and postition the extract manually on the new journal receiver and start the extract.
 
Qn2:This should reach max value may in couple of years.
We want to know if Goldengate can handle the Journal receiver reset automatically ?
May be in newer GG versions ?
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.