Error: F_JZ0A42: The Online Transaction Log File Has Been Reused Already

Issue

The capture job fails with the following error:

F_JZ0A42: The online transaction log file has been reused already, and no matching transaction log backup file is found.

Environment

Source: SAP HANA

Resolution

To resolve this issue, do the following:

1. Reset the capture time.
2. Do a complete refresh on all the tables impacted.
3. Extend the log retention period on the source side, allowing for HVR recovery in case of similar events.

Cause

The HVR feature that creates checkpoints preventing the capture job from reading the already-processed logfiles is unavailable for HANA sources.

After a disconnection or an event when the HANA source isn't available, the HVR capture job needs to return to the start of the last open transaction detected and re-read the changes, causing long-running transactions and growing latency.

In many cases, the transaction logs have already been purged, archived, or moved from the location, causing the job to fail. A strict log retention period increases the chance for the capture job to encounter the above error.