I am trying to save records to a HANA table via a python service. When I hit the URL via postman I am getting the following error even when values are not duplicated:

hdbcli.dbapi.IntegrityError: (301, "unique constraint violated: Table(______),

Index(SYS_TREE_CS#161833_#0_#P0) with error: unique constraint violation in self check for table

H00::DST:en, constraint='GUID',

udiv='3742414332314339343333314544453933413032354543414933353530343031', pos=2942321; indexname=SYS_TREE_CS#161833_#0_#P0") // Werkzeug Debugger

However, if I try to insert the same value directly via insert statement then its successful.

I have checked the DB using following query :

 SELECT GUID,  COUNT(GUID) AS NumOccurrences
        FROM Table_Name
        GROUP BY GUID
        HAVING ( COUNT(GUID) > 1 )

and it does not have duplicate records as well.

Appreciate any suggestions/ inputs.

0

There are 0 best solutions below