OGG填坑笔记:源端更新字段名导致错误

2017-07-14  本文已影响912人  倚岚听风

采集端进程正常,目标端进程显示ABENDED,通过view report 进程名,发现错误日志为:

2017-07-14 09:33:17  INFO    OGG-02756  The definition for table ZOEPRES.PRES_INP_PRES_RECORD_HERB_ADD is obtained from the trail file.
...DAY_QUANTITY= DAY_QUANTITY, HE...
                 ^
Error in COLMAP clause. Unrecognized clause or element.

Source Context :
  SourceModule            : [er.mapping]
  SourceID                : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/app/er/mapping.cpp]
  SourceFunction          : [get_map_entry]
  SourceLine              : [2819]
  ThreadBacktrace         : [17] elements
                          : [/oracle/app/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7ff8af65b0bb]]
                          : [/oracle/app/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7ff8af655254]]
                          : [/oracle/app/ogg/libgglog.so(_MSG_ERR_DB_CLAUSE_ERROR(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x30) [0x7ff8af63c4e0]]
                          : [/oracle/app/ogg/replicat(get_map_entry(ggs::gglib::ggunicode::UString const&, int, wc_def*, int, unsigned int, unsigned int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::ggl
ib::ggmetadata::CMetadataReader*, bool, bool, bool)+0x4d80) [0x5d2430]]
                          : [/oracle/app/ogg/replicat(wc_def::resolve_wc_entry(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, unsigned int*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1
>*, int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*)+0x1ee) [0x6a0f2e]]
                          : [/oracle/app/ogg/replicat(WILDCARD_check_table(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const*, int, unsigned int*, int, unsigned int, ggs::gglib::ggapp::CQualDBObjNa
me<(DBObjType)1>*, int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool)+0x195) [0x6a1545]]
                          : [/oracle/app/ogg/replicat(REP_find_source_file_wc(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int
, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool)+0x1ad) [0x5cb49d]]
                          : [/oracle/app/ogg/replicat(source_file_lookup(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::ggmetadata::CMetadataReader*)+0x488) [0x5b0528]]
                          : [/oracle/app/ogg/replicat(ggs::er::ReplicatContext::processReplicatLoop(ggs::Heartbeat::MapGeneratorParams&)+0xe16) [0x5f45f6]]
                          : [/oracle/app/ogg/replicat(ggs::er::ReplicatContext::run(ggs::Heartbeat::MapGeneratorParams&)+0x29) [0x5e8af9]]
                          : [/oracle/app/ogg/replicat() [0x631b0b]]
                          : [/oracle/app/ogg/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6e9e10]]
                          : [/oracle/app/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6ead9d]]
                          : [/oracle/app/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6eae81]]
                          : [/oracle/app/ogg/replicat(main+0x3b) [0x634a5b]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x351661ed5d]]
                          : [/oracle/app/ogg/replicat() [0x56b119]]

2017-07-14 09:33:17  ERROR   OGG-00919  Error in COLMAP clause.

定位问题为采集端目标表字段变更造成映射不匹配报错

解决办法:修改映射设置(datprm下配置文件的字段映射),重启进程(start 进程名)

上一篇下一篇

猜你喜欢

热点阅读