Register Login

What are typical errors and solutions for corruptions on lower layers?

Updated May 19, 2018

What are typical errors and solutions for corruptions on lower layers?


Comments

  • 17 Feb 2015 6:05 pm Shalesh Singh Helpful Answer

    ERROR:-    Wrong checksum: Calculated <calc_checksum>, stored <act_checksum>.; $lpno$=<log_pageno>; $ppno$=<phys_pageno>

    Details:- 

    SAP HANA calculates checksums for pages written to disk using the CRC32 algorithm.

    global.ini -> [persistency] -> checksum_algorithm = CRC32

    Whenever a page is read from disk the checksum of the page is calculated and compared with the stored checksum. In case of a discrepancy the "wrong checksum" error is thrown and the action terminates.

     

     

  • 17 Feb 2015 6:06 pm Shalesh Singh Helpful Answer

    Solution to the Above error is:-

    A physical block corruption usually doesn't propagate via system replication. Therefore if you have system replication in place, switch to the secondary side.

    If problem is linked to persistence of standalone statistics server: reinitialization of the statisticsserver (SAP Note1950221).

    The same procedure can be used for corruptions in the persistence of the xsengine (SAP Note 1697613) when no actual data is stored there.

    If the above options are not possible, restore a good backup and perform a complete restore.


×