Ogg-01184 Expected 4 Bytes But Got 0 Bytes In Trail (4K)
Situation: A large financial firm experienced OGG-01184 nightly during high-volume batch jobs. Investigation revealed that a temporary filesystem shared with GoldenGate trail directories was filling up due to a separate ETL job’s logs.
Resolution:
Result: Error eliminated completely. Recoverability improved. ogg-01184 expected 4 bytes but got 0 bytes in trail
From a safe RBA before the corruption (e.g., RBA 4819000), step forward record by record:
logdump> pos 4819000
logdump> n
logdump> n
logdump> n
Observe the last good record before 4820192. Is there a gigantic transaction? A LOB update? A BLOB? Large transactions are often culprits because they span multiple trail blocks. Result: Error eliminated completely
start replicat <rep_name>
For advanced diagnosis, use the GoldenGate Logdump utility to inspect the header of the problematic trail file. From a safe RBA before the corruption (e
If the file is empty or corrupt, Logdump will likely report that the file header is missing or invalid.