OGG:Extract Abends With ORA-01403 (Doc ID 2249275.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

2017-03-29 01:27:02 WARNING OGG-02180 Table SYSADM.#Tableau_2_sid:49292277_1 will use legacy trail format to support parameter LOGALLSUPCOLS.

Source Context :
  SourceModule : [ggdb.ora.ddl]
  SourceID : [/scratch/debassah/view_storage/debassah_bug_23025377/oggcore/OpenSys/src/gglib/ggdbora/ddlora.c]
  SourceFunction : [metadata_from_logminer]
  SourceLine : [1105]
  ThreadBacktrace : [22] elements
  : [/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f1f89a643ab]]
  : [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f1f89a5e534]]
  : [/ogg/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_SQL(CSourceContext*, int, char const*, char const*, CMessageFactory::MessageDisposition)+0x41) [0x7f1f89a130f1]]
  : [/ogg/extract(metadata_from_logminer(ggs::gglib::ggunicode::UString const*, unsigned long, unsigned int, unsigned int, ggs::gglib::ggunicode::UString const&, bool, DDLPropertyBuffer&, bool)+0x1908) [0x70c778]]
  : [/ogg/extract(DDLDB_select_ddl_metadata(void*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, char const*, char const*, unsigned int*, unsigned int*, unsigned long, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)0>*, ggs::gglib::ggunicode::UString const*, int, ggs::gglib::ggunicode::UString*, DDLPropertyBuffer&)+0x109) [0x70fe99]]
  : [/ogg/extract(DDLEXT_getCurrentDDL(file_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, extractDDL_t*, int)+0x1c8) [0x64b9c8]]
  : [/ogg/extract(get_extract_source_def(file_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&)+0x16b) [0x6001bb]]
  : [/ogg/extract(MAPPING_add_source_file(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, unsigned int*, unsigned int, recopts_t*, ggs::gglib::ggunicode::UString const&, int*, int, wc_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>&, int, unsigned int, unsigned int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool)+0x27d) [0x5e062d]]
  : [/ogg/extract(get_map_entry(ggs::gglib::ggunicode::UString const&, int, wc_def*, int, unsigned int, unsigned int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool, bool, bool)+0x125c) [0x5e297c]]
  : [/ogg/extract(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*)+0x20f) [0x6811bf]]
  : [/ogg/extract(WILDCARD_check_table(ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const*, int, unsigned int*, int, unsigned int, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1>*, int, ggs::gglib::ggmetadata::CTblMetadata*, ggs::gglib::ggmetadata::CMetadataReader*, bool)+0x271) [0x6818c1]]
  : [/ogg/extract(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)+0x149) [0x5e6af9]]
  : [/ogg/extract(source_file_lookup(ggs::gglib::gglcr::CommonLCR const*, ggs::gglib::ggmetadata::CMetadataReader*)+0x251) [0x5cab61]]
  : [/ogg/extract(ggs::er::ExtractContext::processExtractLoop()+0xb61) [0x607a21]]
  : [/ogg/extract(ggs::er::ExtractContext::run()+0x1e) [0x5fb4fe]]
  : [/ogg/extract() [0x6036e4]]
  : [/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6e0380]]
  : [/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6e15fd]]
  : [/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6e16e1]]
  : [/ogg/extract(main+0x3b) [0x6049cb]]
  : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x32fcc1ed1d]]
  : [/ogg/extract() [0x572c89]]

2017-03-29 01:27:02 ERROR OGG-00663 OCI Error ORA-01403: no data found (status = 100), SQL

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