OGG for DB2 i Doesn't Display Journal Name / Current Journal Receiver Occasionally
(Doc ID 2936004.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
The extract in some situations will generate the following message that does
not include any journal or journal receiver information:
--> 2022-08-09 09:48:41 ERROR OGG-04036 Positioning sequence ID is out of
order, old sequence ID is 00000000001480951812, new sequence ID is
00000000000000000005.
Good message :/ expected message will have the journal info as below...
2022-08-09 08:25:56 ERROR OGG-06613 Journal Sequence Number out of order
in single journal Extract.
Journal: @JRNLIB/OKCJRN. Current Journal Receiver: @JRNLIB/OKC1050080.
Current Journal Sequence Number: 1. Previous Journal Sequence Number:
1,024,275,662.
This is likely due to Journal Sequence Number has been reset for the journal
@JRNLIB/OKCJRN.
Review this and position the Extract manually on the new journal receiver
then start the Extract.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |