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

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #16199
    Pallavik
    Keymaster

    Scenario:

    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

    A] (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.

    B] 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

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us