Adapter abend- OGG-01163 Bad Column Length (28) Specified For Column xxx in Table XXXX (Doc ID 2137965.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 to 12.1.2.1.10 [Release 12.1]
Information in this document applies to any platform.

Symptoms

OGG Adapter abending with the following error when consuming a trail file from IBM i


Source Context :
  SourceModule : [ggstd.conv.endian]
  SourceID : [/scratch/aime1/adestore/views/aime1_adc4150381/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
  SourceFunction : [convCompSQL]
  SourceLine : [638]
  ThreadBacktrace : [13] elements
  : [/oracle/ggadapter/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7ff4b125ce46]]
  : [/oracle/ggadapter/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2af) [0x7ff4b1254d0f]]
  : [/oracle/ggadapter/libgglog.so(_MSG_ERR_MAP_COL_LENGTH_INVALID(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)13> const&, unsigned int, unsigned int, CMessageFactory::MessageDisposition)+0x91) [0x7ff4b1226611]]
  : [/oracle/ggadapter/extract() [0x723e52]]
  : [/oracle/ggadapter/extract(ggConvRecLE(char*, file_def*, int, unsigned char, char, bool)+0x233) [0x7244d3]]
  : [/oracle/ggadapter/extract(process_extract_loop()+0x18e9) [0x5a1eb9]]
  : [/oracle/ggadapter/extract(extract_main(int, char**)+0x523) [0x59f043]]
  : [/oracle/ggadapter/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x72a32f]]
  : [/oracle/ggadapter/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x72812a]]
  : [/oracle/ggadapter/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x729098]]
  : [/oracle/ggadapter/extract(main+0x4a) [0x59d85a]]
  : [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7ff4af35cb15]]
  : [/oracle/ggadapter/extract() [0x4c5249]]

2016-03-24 14:29:26 ERROR OGG-01163 Bad column length (22) specified for column testcol in table POZST04EFT.TEST, maximum allowable length is 20.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms