SAP Note 1731571 - SAP HANA DB: E-table contains wrong values after compression

Symptom
The fact table of a SAP HANA-optimized InfoCube contains wrong values after it has been compressed.
Other terms
SAP HANA, db, wrong, corrupt, compression
Reason and Prerequisites
Prerequisites:
  • SAP HANA DB Revision 30, 31 and 32
  • the first compression execution for a characteristic combination contains several (two or more) records for the same
  • following compressions contained this characteristic combination again
Reason: Due to a programming error the stored procedure in SAP HANA DB does not handle correctly the compression from the f-table into the e-table.
Solution
Apply SAP HANA DB Revision 33 or later

Notes:
    1. SAP HANA Revision 32 fixes already most cases, when this issue can occur, but only Revision 33 contains all fixes
    2. SAP note 1731572 provides a check program to identify affected e-tables
    3. As a workarounddo not execute the fact table compression
    4. You have to rebuild the InfoCubes which contain wrong data. In some cases it is possible to correct the data by hand. SAP HANA development support therefore offers to check whether this is possible and helps you to correct the data if possible.





tags: SAP Note 1731571 - SAP HANA DB: E-table contains wrong values after compression, SAP HANA-optimized InfoCube, SAP HANA DB Revision 30, 31 and 32, 
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved