Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

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

|| 0

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

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