OGG-01163 Bad Column Length (111) Specified For Column (Doc ID 2151580.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

On : 11.2.1.0.28 version, 1 - Oracle DB backend

When attempting to start replicat,
the following error occurs.

ERROR
-----------------------
<

Source Context :
  SourceModule : [ggstd.conv.endian]
  SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]
  SourceFunction : [convCompSQL]
  SourceLine : [597]
  ThreadBacktrace : [13] elements
  : [/ggs/bin/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f726a11ee2e]]
  : [/ggs/bin/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2ec) [0x7f726a11798c]]
  : [/ggs/bin/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)+0x68) [0x7f726a113c64]]
  : [/ggs/bin/replicat() [0x5ef4f4]]
  : [/ggs/bin/replicat(ggConvRecLE(char*, file_def*, int, char, char)+0xad) [0x5ef72d]]
  : [/ggs/bin/replicat(process_extract_loop()+0xb6a) [0x54196a]]
  : [/ggs/bin/replicat(replicat_main(int, char**)+0x759) [0x555999]]
  : [/ggs/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x5f76bf]]
  : [/ggs/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x5f7914]]
  : [/ggs/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x5f7a1b]]
  : [/ggs/bin/replicat(main+0x2c) [0x554b3c]]
  : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x370dc1ecdd]]
  : [/ggs/bin/replicat(__gxx_personality_v0+0x342) [0x4c607a]]

2016-05-11 02:30:16 ERROR OGG-01163 Bad column length (111) specified for column <column_name> in table <tablename>, maximum allowable length is 64.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.