Extract Abends - OGG-00458 Cannot Find Metadata Property DDL_MD_COL_HASNOTNULLDEFAULT

Applies to:

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

Symptoms

The extract abend with the following error: Source Context : SourceModule       : [ggdb.ora.dbx] SourceID                : [/scratch/aime1/adestore/views/aime1_staxk11/oggcore/OpenSys/src/gglib/ggdbora/dbxoci.c] SourceFunction    : [gl_init_query(file_def *, short, char *, DDLPropertyBuffer *)] SourceLine             : [2739] 2012-04-22 22:29:38  ERROR   OGG-00458  Cannot find metadata property DDL_MD_COL_HASNOTNULLDEFAULT.  DDL metadata [,G1='alter index s_act_contact_tiaa_1noparallel',,C6='GGUSER.GGS_MARKER',,C5='240104',,C2='3362040483485',,S='77027',, W='SIEBEL',,X='S_ACT_CONTACT',,Y='INDEX',,Z='ALTER',,A1='53',,A1='53',,C3='SIEBEL',, C4='S_ACT_CONTACT',,C15='NO',,R='8192',,I='313283',,J='',,K='13',,L='1',,M('1')='ROW_ID',, N='VALID',,G11='FALSE',,G7='NO',,G8='NO',,O='NO',,P='NO',,G2='NO',,C('1')

Cause

The issue is due to missing DDL metadata properties. This is transient due to history records that were written before ddl_setup.sql was run to upgrade the DDL trigger/package.The issue is been tracked via bug- 13996125.

Solution

Use an OGG build (bug 13996125 ) which has the additional functionality to skip these problematic records.
With the changes done via bug 13996125 we can skip these records by setting the following parameter in the extract.

DDLERROR _SKIPDDL -1

A warning message is produced for each skipped records.
We need to manually execute any skipped DDL’s in the target so that the replicat will not have any issues due to missing DDLsAssociated Km's
OGG GGS_STICK getting locked during the DDL Upgrade (Doc ID 1441479.1)
DDL TRIGGER RESULTING IN GoldenGate ORA-01426: NUMERIC OVERFLOW, OGG-00524, ORA-06512 (Doc ID 1456177.1)

References

BUG:13996125 - EXTRACT ERROR "CANNOT FIND METADATA PROPERTY DDL_MD_COL_HASNOTNULLDEFAULT"