GoldenGate Replicat Aborts with ERROR OGG-01296 Error Mapping from {0} to {1} (Doc ID 1575597.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 to 12.1.2.0.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.
The Replicat is connecting to an Oracle database.

Symptoms

 The REPLICAT report contains the following error, before aborting.

2013-07-31 07:54:44  WARNING OGG-00869  No unique key is defined for table 'TABLE1'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using following columns in default map by name:
  COL_2, COL_3, COL_4, COL_5
Using the following key columns for target table SCHEMA1.TABLE1: COL_2, COL_3, COL_4, COL_5.


2013-07-31 07:54:44  WARNING OGG-01503  Aborting BATCHSQL transaction. Mapping error.

2013-07-31 07:54:44  WARNING OGG-01137  BATCHSQL suspended, continuing in normal mode.

2013-07-31 07:54:44  WARNING OGG-01003  Repositioning to rba 6740350 in seqno 1.

2013-07-31 07:54:44  WARNING OGG-01431  Aborted grouped transaction on 'SCHEMA1.TABLE1', Mapping error.

2013-07-31 07:54:44  WARNING OGG-01003  Repositioning to rba 6740350 in seqno 1.

2013-07-31 07:54:44  WARNING OGG-01151  Error mapping from SCHEMA1.TABLE1 to SCHEMA1.TABLE1.

2013-07-31 07:54:44  WARNING OGG-01003  Repositioning to rba 6740350 in seqno 1.

Source Context :
  SourceModule            : [er.errors]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150267/oggcore/OpenSys/src/app/er/errors.cpp]
  SourceFunction          : [take_rep_err_action]
  SourceLine              : [632]
  ThreadBacktrace         : [8] elements
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f465bc90abe]]
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f465bc8980c]]
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/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) [0x7f465bc856cd]]
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bool)+0xaa5) [0x5232f1]]
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/replicat(process_extract_loop()+0x2e42) [0x53d432]]
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/replicat(main+0x732) [0x54e642]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x37f501d994]]
                          : [/app/oracle/product/ogg_11.2.1.0.6_home/replicat(__gxx_personality_v0+0x322) [0x4c16ba]]

2013-07-31 07:54:44  ERROR   OGG-01296  Error mapping from SCHEMA1.TABLE1 to SCHEMA1.TABLE1.

 

Changes

No changes were made to the REPLICAT configuration, where previously it had been working.

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