OGG 12.2 – Extract Abend – OGG-00458 Cannot Find Metadata Property

OGG 12.2 – Extract Abend – OGG-00458 Cannot Find Metadata Property

Extract Process Abends with the below error,

2016-07-05 00:03:34 ERROR OGG-00458 Cannot find metadata property G41. DDL metadata [,G1='alter table "schema"."table" shrink space CHECK ',,C6='GGS.GGS_MARKER',,C5='6399704',,C2='4377220081',,S='99751',,W='schema',,X='table',,Y='TABLE',,Z='ALTER',,A1='104',,A1='104',,..........

Cause of the Issue was, by default “auto space advisor” is enabled in the Oracle Database. This advisor, shrinks the space of large tables and this causes the Oracle GoldenGate Extract process to get abended with the below error,

2016-07-05 00:03:34 ERROR OGG-00458 Cannot find metadata property G41. DDL metadata [,G1='alter table "schema"."table" shrink space CHECK ',,C6='GGS.GGS_MARKER',,C5='6399704',,C2='4377220081',,S='99751',,W='schema',,X='table',,Y='TABLE',,Z='ALTER',,A1='104',,A1='104',,..........

This is a Bug,

Bug 23154554 - Extract abends: OGG-00458 Cannot find metadata property G23. DDL metadata

But there is a Workaround for this, you can disable the “auto space advisor” feature which is the cause for triggering shrink space for large tables.

Steps to disable the “auto space advisor”

1. Check the status of the “auto space advisor”.

SQL> SELECT client_name, status FROM dba_autotask_client;
set lines 180 pages 1000
col client_name for a40
col attributes for a60
select client_name, status,attributes,service_name from dba_autotask_client;

2. Execute the below to disable the “auto space advisor”.

BEGIN
DBMS_AUTO_TASK_ADMIN.disable(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/

3. Check if the “auto space advisor” is disabled.

set lines 180 pages 1000
col client_name for a40
col attributes for a60
select client_name, status,attributes,service_name from dba_autotask_client;

Restart the Extract process after disabling the “auto space advisor”.

Note: Please check with your Oracle Core DBA before disabling this “auto space advisor”..