系统环境
oracle11.2.0.4+OGG12.2.0.1.0
错误信息
ERROR OGG-01161 Bad column index (73) specified for table SC.T_SB_CZZ, max columns = 73.
详细错误信息
2021-01-09 02:26:28 INFO OGG-02759 The definition for table SC.T_SB_CZZ is obtained from the target database.
2021-01-09 02:26:28 INFO OGG-06511 Using following columns in default map by name: OBJ_ID, SBBM, DXMPYXKID, SBMC, YXBH, YWDW, SSZF, ZCXZ, ZCDW, WHBZ, DYDJ, JGDY, XS, XB, SFJD, JDBZ, DYCS, SFYSW, TZLY.
2021-01-09 02:26:28 INFO OGG-06510 Using the following key columns for target table SC.T_SB_CZZ: OBJ_ID.
Source Context :
SourceModule : [ggstd.conv.endian]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
SourceFunction : [convCompSQL]
SourceLine : [600]
ThreadBacktrace : [15] elements
: [/yjgk/yjgk2/ogg_12/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f536e25cf1b]]
: [/yjgk/yjgk2/ogg_12/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f536e2570a4]]
: [/yjgk/yjgk2/ogg_12/libgglog.so(_MSG_ERR_MAP_COL_INDEX_INVALID(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, int, CMessageFactory::MessageDisposition)+0x50) [0x7f536e250bc4]
]
: [/yjgk/yjgk2/ogg_12/replicat() [0x7ada0f]]
: [/yjgk/yjgk2/ogg_12/replicat(ggConvRecLE(char*, file_def*, int, unsigned char, char, bool)+0x4f2) [0x7ae182]]
: [/yjgk/yjgk2/ogg_12/replicat(ggs::gglib::gglcr::CommonLCR::normalize()+0x51) [0x81b6e1]]
: [/yjgk/yjgk2/ogg_12/replicat(ggs::er::ReplicatContext::processReplicatLoop(ggs::Heartbeat::MapGeneratorParams&)+0xe71) [0x5e4661]]
: [/yjgk/yjgk2/ogg_12/replicat(ggs::er::ReplicatContext::run(ggs::Heartbeat::MapGeneratorParams&)+0x29) [0x5d8b09]]
: [/yjgk/yjgk2/ogg_12/replicat() [0x621b1b]]
: [/yjgk/yjgk2/ogg_12/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d9d50]]
: [/yjgk/yjgk2/ogg_12/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6dacdd]]
: [/yjgk/yjgk2/ogg_12/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6dadc1]]
: [/yjgk/yjgk2/ogg_12/replicat(main+0x3b) [0x624a6b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x32e161ed1d]]
: [/yjgk/yjgk2/ogg_12/replicat() [0x55b0a9]]
2021-01-09 02:26:28 ERROR OGG-01161 Bad column index (73) specified for table SC.T_SB_CZZ, max columns = 73.
问题分析与解决
1、查看该表结构是否与源端一致
发现确定源端进行了字段添加,准备在目标库也添加相应的字段,后面与源端数据库人员沟通后,发现他们对许多业务表都进行了升级操作,需要他们提供完整了升级脚本。
2、执行相应的升级脚本即可解决