Introduction

How to identify HANA backup log file from the sequence number in the error message.

Environment

HVR

Answer

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

Steps

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
= 10286855811

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