Hi,
You can get ” OGG-01172 Discard file (/data/Goldengate/discard/REP01_discard.txt) exceeded max bytes (500000000) ” error while Replicat is running.
OGG-01172 Discard file Exceeded max bytes
When I check report file of Goldengate Replicat Process, I saw OGG-01172, OGG-01668 errors like following.
GGSCI (MehmetSalih) 27> view report REP01 ........................ .................. discardfile /data/Goldengate/discard/REP01_discard.txt, append, megabytes 500 Source Context : SourceModule : [er.main] SourceID : [/scratch/angorant/view_storage/angorant_ogg_12978807_x64/oggcore/OpenSys/src/app/er/rep.c] SourceFunction : [output_discard_info] SourceLine : [14056] ThreadBacktrace : [9] elements : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x31f261d9c4]] : [/data1/Goldengate/replicat(__gxx_personality_v0+0x1da) [0x4e43ca]] 2019-05-16 13:38:04 ERROR OGG-01172 Discard file (/data/Goldengate/discard/REP01_discard.txt) exceeded max bytes (500000000). 2019-05-16 13:38:04 ERROR OGG-01668 PROCESS ABENDING.
OGG-01668 PROCESS ABENDING
To solve OGG-01172 error, increase discardfile size parameter in the replicat parameter file like following. Change following line from 500mb to 5000 or more MB, it will be solved.
discardfile /data/Goldengate/discard/REP01_discard.txt, append, megabytes 5000
GGSCI (MehmetSalih) 27> edit params REP01
discardfile /data/Goldengate/discard/REP01_discard.txt, append, megabytes 5000
Start Goldengate Replicat process and monitor it.
GGSCI (MehmetSalih) 28> start REP01
Sending START request to MANAGER ...
REPLICAT REP01 starting
GGSCI (MehmetSalih) 29>
GGSCI (MehmetSalih) 29> info REP01
REPLICAT REP01 Last Started 2019-05-16 13:40 Status RUNNING
Checkpoint Lag 00:32:59 (updated 00:00:00 ago)
Log Read Checkpoint File /data/Goldengate/dirdat/rt061069
2019-05-16 13:07:27.412499 RBA 19983356
GGSCI (MehmetSalih) 30> !
info REP01
REPLICAT REP01 Last Started 2019-05-16 13:40 Status RUNNING
Checkpoint Lag 00:09:35 (updated 00:00:00 ago)
Log Read Checkpoint File /data/Goldengate/dirdat/rt061070
2019-05-16 13:30:55.411576 RBA 20215450
GGSCI (MehmetSalih) 31> !
info REP01
REPLICAT REP01 Last Started 2019-05-16 13:40 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Log Read Checkpoint File /data/Goldengate/dirdat/rt061070
2019-05-16 13:40:04.412345 RBA 38380842
OGG-01172, OGG-01668 errors has been solved.