How To Identify HANA Backup Log File From the Sequence Number in the Error Messagelink
Introductionlink
How to identify the HANA backup log file from the sequence number in the error message.
Environmentlink
HVR 5
Answerlink
This procedure is helpful when the HANA backup log file needs to be produced for investigation.
Stepslink
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 1link
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 2link
We are looking for the backup with %s <= sequence_from_the_error < %e. In this case, it will be %s <= 10286855811< %e.