OGG ORA-01403 When Using Different Columns on Supplemental Logging and KEYCOLS (Doc ID 1347976.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
Affected Database: Oracle
***Checked for relevance on 11-Mar-2013***

Symptoms

The following error appears at the ggserr.log

Aborted grouped transaction on 'GGTARGET.TESTN', Database error 1403 ().
Repositioning to rba 3603 in seqno 0.
SQL error 1403 mapping GGSOURCE.TESTN to GGTARGET.TESTN.
Repositioning to rba 3603 in seqno 0.
Error mapping from GGSOURCE.TESTN to GGTARGET.TESTN.
PROCESS ABENDING.


If the column defined for supplemental logging is different than the one used with KEYCOLS in the extract and replicat parameter files at the TABLE and MAP statements then it is possible to receive the above error.

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