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

Integrity Constraint Violation Error loading into SAP HANA Tables

144 Views

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