How to identify HANA backup log file from the sequence number in the error message
This procedure is helpful when the Hana backup log file needs to be produced for investigation.
For example below is the error message
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
The log_backup file has format: log_backup_%v_%p_%s_%e.%t where %s – start sequence, %e – end sequence.
Or optionally you can use an online converter to do this https://www.binaryhexconverter.com/hex-to-decimal-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