美文网首页
OGG填坑笔记:源端更新字段名导致错误

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

作者: 倚岚听风 | 来源:发表于2017-07-14 10:22 被阅读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 进程名)

    相关文章

      网友评论

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

          本文链接:https://www.haomeiwen.com/subject/vcdnhxtx.html