MSSQL CDC Extract Abends With OGG-04036 Positioning Sequence ID Is Out Of Order

(Doc ID 2373316.1)

Last updated on MARCH 15, 2018

Applies to:

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

Symptoms

Oracle Golden Gate CDC Extract abends with the following errors:

2018-02-11 07:56:32 ERROR OGG-04036 Positioning sequence ID is out of order, old sequence ID is 0019c474:00071d60:0001-0019c474:04001c43:0000,
new sequence ID is 0019c474:00071d60:0001-0019c474:00071c43:0044.

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