Error: F_JZ0A4E: No Matching Transaction Log Backup File Is Found

Issue

Capture fails with the following error:

F_JZ0A4E: No matching transaction log backup file is found for seq# <expected_sequence>, but a newer log backup file (start seq# <start_sequence>, end seq# <end_sequence>) exists.

Environment

• HVR 6
• Source RDBMS: Hana
• Capture method: Archive Only (Capture_Method=ARCHIVE_ONLY)

Resolution

To resolve this issue:

1. Stop the capture job.
2. Identify out-of-sequence transaction log files in the source archive or backup directory. To help identify stale logs from the pre-refresh sequence, convert the hexadecimal sequence numbers in the error message to decimal and compare them with the sequence numbers of the transaction log files in the directory.
3. Remove the out-of-sequence transaction log files from the active directory. You can delete them, archive them, or move them to a secure backup directory outside the HVR scan path.
4. Start the capture job.

Cause

This issue occurs when a database refresh resets the transaction log sequence numbers while older archive logs remain in the directory scanned by HVR.

In ARCHIVE_ONLY mode, we treat the configured directory as the source of transaction logs and processes the files in sequence. After a database refresh, the database may generate a new log sequence with lower sequence numbers. If the same directory still contains pre-refresh logs with higher sequence numbers, we interpret them as newer log backups. Because the expected next log file in the current sequence is missing, Capture returns the above error.