After Source Upgrade to 19c, 12.2 Replicat Abends with OGG-01431 Aborted Grouped Transaction, Mapping Error.
(Doc ID 2702715.1)
Last updated on JULY 18, 2023
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 |