Online Tutorials & Training Materials | STechies.com
Register Login

What is the reason of duplicate entries in primary key of the SAP HANA DB.

03 Oct 2012 3:48 pm || 0

You are facing duplicate entries in the primary key of your table in the SAP HANA DB.

Prerequisite: You are using SAP HANA DB revision 36 or previous
Reason: Due to a programming error it can happen that duplicate entries in the primary key exist in a table. This may happen during the creation of the inverted compressed index or due to missing entries in the replay log caused by out-of-memory situations.

Update to SAP HANA DB Revision 37 or later to overcome the issue