Skip to Content

SAP "unique constraint violated" error in HanaBulkCopy

Dec 12, 2017 at 08:53 PM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers