No Unique Key Is Defined For Table - OGG-01296 Error mapping (Doc ID 2017835.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms

Replication was failing due to:

2015-06-02 16:26:50  WARNING OGG-01431  Aborted grouped transaction on 'SCHEMA.TABLE', Mapping error.
2015-06-02 16:26:50  WARNING OGG-01151  Error mapping from SCHEMA.TABLE to SCHEMA.TABLE.

Source Context :
 SourceModule            : [er.errors]
 SourceID                : [/scratch/mmar/view_storage/mmar_20635622_lin64/oggcore/OpenSys/src/app/er/errors.cpp]
 SourceFunction          : [take_rep_err_action]
 SourceLine              : [880]
 ThreadBacktrace         : [14] elements
                         : [/u01/app/oracle/product/ggmastperf/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f55933ade9e]]
                         : [/u01/app/oracle/product/ggmastperf/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7f55933a8bb0]]
                         : [/u01/app/oracle/product/ggmastperf/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition)+0x53) [0x7f55933a1df1]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bool)+0x141c) [0x579cb4]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int)+0x291d) [0x5c588d]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(process_record(file_def*&, short&, extr_ptr_def*&, extr_ptr_def*&, int&, bool&, int&, int&, bool)+0x654) [0x5ca0c4]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(process_replicat_loop()+0xe11) [0x5a6f91]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(replicat_main(int, char**)+0x5ca) [0x5c034a]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x693b6f]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x693ea4]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x693fab]]
                         : [/u01/app/oracle/product/ggmastperf/replicat(main+0x3f) [0x5befdf]]
                         : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3e6881ed5d]]
                         : [/u01/app/oracle/product/ggmastperf/replicat() [0x50e929]]

2015-06-02 16:26:50  ERROR   OGG-01296  Error mapping from SCHEMA.TABLE to SCHEMA.TABLE.

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