My Oracle Support Banner

After Source Upgrade to 19c, 12.2 Replicat Abends with OGG-01431 Aborted Grouped Transaction, Mapping Error. (Doc ID 2702715.1)

Last updated on SEPTEMBER 04, 2020

Applies to:

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

Symptoms

Oracle GoldenGate (OGG) 12.2 replicat reports the following warnings repeatedly in the report file, for the same RBA and SEQNO:


WARNING OGG-01431 Aborted grouped transaction on '<USER>.<TABLE>', Mapping error.
WARNING OGG-01003 Repositioning to rba 2240 in seqno 129.

-- the following error may also follow:

ERROR   OGG-01296  Error mapping from <USER>.<TABLE> to <USER>.<TABLE>.

 

-- OR --

OGG 12.2 replicat abends with:

ERROR   OGG-01161  Bad column index (#) specified for table <USER>.<TABLE>, max columns = #.

Changes

OGG 12.2 source was upgraded to OGG 19.1.

No extra steps were taken with extracts during the source upgrade, in regards to trail file format.

Per the following:

19.1 Release Notes for Oracle GoldenGate
Chapter 2 What’s New in this Release
2.2.4 Release 19c (19.1.0) - May 2019 Initial Release

Extract Default Trail File Version: 

The primary Extract writes trail file in the same format as existing trail file format when you upgrade to Oracle GoldenGate 19c, unless you explicitly specify the trail file format version using the FORMAT RELEASE option. This behavior change prevents subsequent Replicat to abend if replicat is not upgraded.

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


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