Solution : https://service.sap.com/sap/support/notes/1891354 (SAP Service marketplace login required)
Summary :
SAP HANA DB revisions 60 and 61 have a known issue where duplicate rows can be inserted into column store tables due to a programming error. This can occur when an insert of an existing record happens concurrently with a rollback of a DELETE|UPSERT|UPDATE operation on the same record during primary key verification. Users of SAP HANA where these conditions apply should update to revision 62 or higher to resolve the issue. Data correction can be done by either reloading from the source system or manually deleting duplicates, using tools like uniqueChecker mentioned in SAP note 1666976.
Key words :
01 2020199 sap hana sps 08 database revision 80 2062555 sap hana sps 08 database revision 83 1908139 sap hana database revision 64 1912291 sap hana database revision 65 1913174 sap hana database revision 66 2076890 sap hana sps 08 database revision 84 1918550 sap hana database revision 67 1920852 sap hana database revision 68 2085810 sap hana sps 08 database revision 85, sap notes 1920852 sap hana database revision 68 1918550 sap hana database revision 67 1913174 sap hana database revision 66 1912291 sap hana database revision 65 1908139 sap hana database revision 64 1901670 sap hana database revision 63 1894285 sap hana appliance, 1935871 sap hana sps 06 database maintenance revisions 1944771 sap hana sps 07 database revision 70 1974423 sap hana sps 07 database revision 71 2123714 sap hana sps 08 database maintenance revision 85, 04 1901670 sap hana database revision 63 2047977 sap hana sps 08 database revision 82 2107518 sap hana sps 08 database maintenance revision 85, 01 1990011 sap hana sps 07 database revision 73 2003736 sap hana sps 07 database revision 74 1514967 sap hana, 02 1981393 sap hana sps 07 database revision 72 2029271 sap hana sps 07 database maintenance revision 74, sap hana database 2043465 sap hana sps 07 database maintenance revision 74, 03 2036554 sap hana sps 08 database revision 81 1894285 sap hana appliance, sap hana database 1666976 uniquechecker usage description 1523337 sap hana database 1, 02 1666976 uniquechecker usage description 2036266 sap hana sps 07 database maintenance revision 74
Related Notes :
| 1920852 | |
| 1918550 | |
| 1913174 | SAP HANA Database Revision 66 |
| 1912291 | SAP HANA Database Revision 65 |
| 1908139 | SAP HANA Database Revision 64 |
| 1901670 | SAP HANA Database Revision 63 |
| 1894285 | SAP HANA appliance: Revision 62 of SAP HANA database |
| 1666976 | uniqueChecker usage description |
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |
| 1935871 | SAP HANA SPS 06 Database Maintenance Revisions |
| 1944771 | SAP HANA SPS 07 Database Revision 70 |
| 1974423 | SAP HANA SPS 07 Database Revision 71 |
| 2123714 | SAP HANA SPS 08 Database Maintenance Revision 85.02 |
| 1981393 | SAP HANA SPS 07 Database Revision 72 |
| 2029271 | SAP HANA SPS 07 Database Maintenance Revision 74.02 |
| 2036266 | SAP HANA SPS 07 Database Maintenance Revision 74.03 |
| 2036554 | SAP HANA SPS 08 Database Revision 81 |
| 2043465 | SAP HANA SPS 07 Database Maintenance Revision 74.04 |
| 2047977 | SAP HANA SPS 08 Database Revision 82 |
| 2107518 | SAP HANA SPS 08 Database Maintenance Revision 85.01 |
| 1990011 | SAP HANA SPS 07 Database Revision 73 |
| 2003736 | SAP HANA SPS 07 Database Revision 74 |
| 2016740 | SAP HANA SPS 07 Database Maintenance Revision 74.01 |
| 2020199 | SAP HANA SPS 08 Database Revision 80 |
| 2062555 | SAP HANA SPS 08 Database Revision 83 |
| 2076890 | SAP HANA SPS 08 Database Revision 84 |
| 2085810 | SAP HANA SPS 08 Database Revision 85 |