How To Identify HANA Backup Log File From the Sequence Number in the Error Message

Question

How can I identify the HANA backup log file from the sequence number in the error message?

Environment

HVR 5

Answer

This procedure is helpful when the HANA backup log file needs to be produced for investigation.

Steps

For example, the error message below:

F_JZ0A87: A partition-local rowid value 0 is out of the expected range 1..1125899906842623.

F_JT140E: The previous error occurred during a update_after operation for table id 8118452 (zpurt_sitecodes [sapabap1.zpurt_sitecodes] with base columns (“$rowid$” mandt sitesystem sitecode ekrog lifnr bestcode lifnoa lifpi intlsite forcurr status erdat ernam ertim chdat chnam chtim) at SEQ 0x26524f683 in transaction 0x237a09a from scanned record 1294761 which has log position 0x26524f683 and timestamp 2018-11-07T21:30:35-07:00.

Step 1

Convert the SEQ number from hex to decimal. In this case, the SEQ number is 0x26524f683.

(2 * (16^8)) + (6*(16^7)) + (5*(16^6)) + (2*(16^5)) + (4*(16^4)) + (15*(16^3)) + (6*(16^2)) + (8*(16^1)) + (3*(16^0))
= 8589934592 + 1610612736 + 83886080 + 2097152 + 262144 + 61440 + 1536 +128 + 3
= 10286855811

The log_backup file has the format, log_backup_%v_%p_%s_%e.%t, where %s – start sequence, %e – end sequence.

You can also use an online converter.

Step 2

We are looking for the backup with %s <= sequence_from_the_error < %e. In this case, it will be %s <= 10286855811< %e.