OGG-01296 Error mapping from SAP.BHU1000 to SAP_SCHEMA.BHU1000
Situation
We have added new tables to the existing Extract & Replicate. after adding the tables in the replicate, Replicate got aborted with the below error message.
2014-04-17 14:23:19 WARNING OGG-00869 No unique key is defined for table 'BHU1000'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2014-04-17 14:23:19 WARNING OGG-01503 Aborting BATCHSQL transaction. Mapping error.
2014-04-17 14:23:19 WARNING OGG-01137 BATCHSQL suspended, continuing in normal mode.
2014-04-17 14:23:19 WARNING OGG-01003 Repositioning to rba 95972561 in seqno 309.
2014-04-17 14:23:19 WARNING OGG-01431 Aborted grouped transaction on 'SAP_SCHEMA.BHU1000', Mapping error.
2014-04-17 14:23:19 WARNING OGG-01003 Repositioning to rba 95972561 in seqno 309.
2014-04-17 14:23:19 WARNING OGG-01151 Error mapping from SAP.BHU1000 to SAP_SCHEMA.BHU1000.
2014-04-17 14:23:19 WARNING OGG-01003 Repositioning to rba 95972561 in seqno 309.
Source Context :
SourceModule : [er.errors]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction : [take_rep_err_action]
SourceLine : [632]
ThreadBacktrace : [8] elements
: [/oracle/product/ggs_112105/CRIC1/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b83a93900de]]
: [/oracle/product/ggs_112105/CRIC1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x2b83a9388dfc]]
: [/oracle/product/ggs_112105/CRIC1/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) [0x2b83a9384cc7]]
: [/oracle/product/ggs_112105/CRIC1/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bo
ol)+0xaa5) [0x520cc1]]
: [/oracle/product/ggs_112105/CRIC1/replicat(process_extract_loop()+0x2e42) [0x53ad82]]
: [/oracle/product/ggs_112105/CRIC1/replicat(main+0x732) [0x54bf02]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3cd661d9c4]]
: [/oracle/product/ggs_112105/CRIC1/replicat(__gxx_personality_v0+0x31a) [0x4c035a]]
2014-04-17 14:23:19 ERROR OGG-01296 Error mapping from SAP.BHU1000 to SAP_SCHEMA.BHU1000.
FINDING & SOLUTION
1) We found that table doesn’t have any primary key columns
2) We found that table has 4 indexes in the source side (extract) but no indexes created on the replicate side while adding tables in the replicate.
3) We found multiple check constraints are created but no primary key constraints.
We have created all the indexes on the target side (Replicat database) for the table(similar one like source) and try to start the replicate.
We found apply process goes fine and that solves the problem.
Happy reading JJJ
