Skip to Content
avatar image
Former Member

SAP "unique constraint violated" error in HanaBulkCopy

I am working on SAP ADO.NET project. The HanaBulkCopy seem to be working well the previous weeks and suddenly the operation fails on a certain record number (say record 1200). I tried running the program on another environment, with different data and surprisingly, the bulk copy errors on the 1200th record insert.

To debug this, prior calling the WriteToServer method, I exported the datatable to excel and checked if there are duplicates prior the 1200th record but there's not any. Since someone else is managing the Hana tables, I asked what were the rules that identifies as unique table and after checking none of them were violated, I wonder why the insert still fails. Any ideas on this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers