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:
- Reset the capture time.
- Do a complete refresh on all the tables impacted.
- 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.