直接上报错:
2020-09-10 15:48:23 WARNING OGG-01151 Error mapping from CUX.CUX_WIP_JOB_BI_HEADERS_IFC to ODS_BUSINESS.CUX_WIP_JOB_BI_HEADERS_IFC.
Source Context :
SourceModule : [er.errors]
SourceID : [/scratch/debassah/view_storage/debassah_bug22722962/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction : [take_rep_err_action]
SourceLine : [935]
ThreadBacktrace : [15] elements
: [/biee/app/ggs12c/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7fc481e3ef0b]]
: [/biee/app/ggs12c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7fc481e39094]]
: [/biee/app/ggs12c/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> co
nst&, CMessageFactory::MessageDisposition)+0x50) [0x7fc481e327ff]]
: [/biee/app/ggs12c/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, std_rec_hdr_def*, char*, file_def*, bool)+0x17ab) [0x5a471c]]
: [/biee/app/ggs12c/replicat(replicate_io(ggs::gglib::ggdatasource::DataSource*, file_def*, ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, extr_ptr_def*, int*, int)
+0xac2) [0x625b32]]
: [/biee/app/ggs12c/replicat(process_record(ggs::gglib::ggdatasource::DataSource*, file_def*&, ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::gglcr::CommonLCR*, short&, extr_ptr_def*&
, extr_ptr_def*&, int&, int&, int&, bool)+0x2f1) [0x62cc71]]
: [/biee/app/ggs12c/replicat(ggs::er::ReplicatContext::processReplicatLoop(ggs::Heartbeat::MapGeneratorParams&)+0x10ee) [0x5e487e]]
: [/biee/app/ggs12c/replicat(ggs::er::ReplicatContext::run(ggs::Heartbeat::MapGeneratorParams&)+0x29) [0x5d8b09]]
: [/biee/app/ggs12c/replicat() [0x6218cb]]
: [/biee/app/ggs12c/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d9b30]]
: [/biee/app/ggs12c/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6daabd]]
: [/biee/app/ggs12c/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6daba1]]
: [/biee/app/ggs12c/replicat(main+0x3b) [0x62481b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x318ae1ecdd]]
: [/biee/app/ggs12c/replicat() [0x55b0a9]]
2020-09-10 15:48:23 ERROR OGG-01296 Error mapping from CUX.CUX_WIP_JOB_BI_HEADERS_IFC to ODS_BUSINESS.CUX_WIP_JOB_BI_HEADERS_IFC.
看报错 是mapping出现了问题,正常情况下应该是表结构不一致导致的,但是我对比了下表结构是完全一直的,而且我用了sourcedefs文件 理论上是不会出现表结构map异常的问题
进一步分析:
1.关于sourcedefs文件,发现有warning
2020-09-10 15:48:22 WARNING OGG-02761 Source definitions file, ./dirdef/ora_e_e2h_03.def, is ignored because trail file ./dirdat/h3000000003 contains table definitions.
没有到用def文件,再查了一下资料,OGG 12.2以后,SOURCEDEFS和ASSUMETARGETDEFS都已经没有用了。。
(https://www.oracle.com/technetwork/database/availability/con8737-goldengate-12-2-2811120.pdf)
2.关于表结构map error的问题
最后定位到原因是map error的表 source端有主键而target端没有主键