GoldenGate Replicat Aborts with ERROR OGG-01296 Error Mapping from {0} to {1}
(Doc ID 1575597.1)
Last updated on NOVEMBER 13, 2024
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.
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
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 |
GoldenGate Solutions |
Oracle Database Solutions |