Skip to Content
Former Member
Oct 21, 2013 at 02:49 PM

Integrity Constraint Violation Error loading into SAP HANA Tables


I have been getting this error while I was trying to load data into SAP HANA table from Oracle Exadata as a source. I tried all options in DS job but still I have been getting this error. There are no transformations and it's straight pull. I was reading somewhere that I need to disable the primary keys in HANA tables and that will load the data successfully. Any ideas here on how to resolve this issue?

Job <JB_XXXX> is terminated due to error <70404>

DBS-070404 SQL submitted to ODBC data source <HANA_CONN> resulted in error Integrity constraint violation