Tuesday, April 18, 2023

ERROR OGG-01172 Discard file exceeded max bytes

Problem:

On a Goldengate 12.2 setup, one of the replicate processes get ABENDED with below error:

ERROR   OGG-01172  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Discard file (/goldengate/gghome/dirrpt/rep1.dsc) exceeded max bytes (2000000000).


Solution:


You can modify the parameter file for the same processes increasing the maximum size of the discard file which can reach up to 2048 MB like this:

DISCARDFILE ?GG_HOME/dirrpt/rep1.dsc, APPEND, MEGABYTES 2048

But again, once it reaches 2048 MB the process will ABEND, no matter what option you will use APPEND/PURGE/ROLLOVER , as this option works only at the time the replicate process starts up!

The other solution is to simply disable the reporting of the discarded transactions in the discard file if you don't care about them.

Remove or hash the entire line for the parameter DISCARDFILE and replace it with NODISCARDFILE parameter inside the replicate parameter file:

-- DISCARDFILE ?GG_HOME/dirrpt/rep1.dsc, APPEND, MEGABYTES 2048
NODISCARDFILE

Note: Both parameters DISCARDFILE  & NODISCARDFILE are mutually exclusive, which means you cannot use both of them in the same parameter file, you have to use only one; otherwise the process will get ABENDED with the below cute error when you try to start it up:

ERROR   OGG-10107 Parsing error, parameter [nodiscardfile] conflicts with parameter [discardfile]


References
:

https://docs.oracle.com/goldengate/c1221/gg-winux/GWURF/discardfile-nodiscardfile.htm#GWURF462

https://docs.oracle.com/en/middleware/goldengate/non-stop/12.3.0.1/reference/discardrollover.html#GUID-9A8B91D2-F0D7-46ED-B553-D72E76D9BCE6

No comments:

Post a Comment