DDL TRIGGER RESULTING IN GoldenGate ORA-01426: NUMERIC OVERFLOW, OGG-00524, ORA-06512
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
Extract abended with error:
2012-02-29 11:45:31 ERROR OGG-00524 Oracle GoldenGate Capture for Oracle, extgrp1.prm: Error in DDL trigger has been detected: ERROR: DDL sequence , marker sequence , DDL trace log file [/usr/local/opt/oracle/admin/ipag1pdb/diag/rdbms/ipag1pdb_dg1/ipag1p1/trace\ggs_ddl_trace.log], error code -1426 error message ORA-01426: numeric overflow, error stack: ORA-06512: at "GGSUSER.DDLREPLICATION", line 95 ORA-06512: at "GGSUSER.DDLREPLICATION", line 234 ORA-06512: at line 94 . Please investigate trace log file or contact Oracle Support.
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