OGG Extract Abends With ERROR OGG-00459 Cannot find metadata property DDL_MD_COL_NUM for object <table name> (Doc ID 2237840.1)

Last updated on MARCH 07, 2017

Applies to:

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

Symptoms

Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.161018 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160928.0200.1_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct 26 2016 14:24:11

Extract abends with following error

Source Context :
SourceModule : [ggdb.ora.ddl]
SourceID : [/scratch/mmar/view_storage/mmar_24513832_linux64/oggcore/OpenSys/src/gglib/ggdbora/ddloraext.c]
SourceFunction : [DDLORA_get_odbc_primary_key]
SourceLine : [1785]
ThreadBacktrace : [29] elements
: [/opt/oracle/ogg/libgglog.so(_MSG_ERR_DDL_METADATA_MISSING_OBJECT_PROPERTY
: [/opt/oracle/ogg/extract(DDLORA_get_odbc_primary_key(file_def*, DDLPropertyBuffer*, bool)+0x295) [0x70ba75]]
: [/opt/oracle/ogg/extract(DBUTIL_ddl_init_query(file_def*, short, char*, DDLPropertyBuffer*)+0x1f) [0x71678f]]
: [/opt/oracle/ogg/extract(DBUTIL_ddl_metadata_change(file_def*, ggs::gglib::ggapp::CDBObjName<(DBObjType)
: [/opt/oracle/ogg/extract(DDLEXT_getCurrentDDL(file_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, extractDDL_t*, int)+0x45a) [0x63ec0a]]
: [/opt/oracle/ogg/extract() [0x5646e9]]

2017-01-24 22:30:16 ERROR OGG-00459 Cannot find metadata property DDL_MD_COL_NUM for object REQUEST_ID. DDL metadata [,G1='alter index "ECT_VB"."NVB_REQUEST_CONTEXT_2" shrink space CHECK ',

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