Integrity Constraint Violation Error loading into SAP HANA Tables

[Former Member]

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

[Prabhith]

Hi Former Member,

This seems to be purely a data related issue.

Please check and confirm whether the source table has duplicate records.

In case if the source contains the duplicate records, discuss with the source team and understand the reason for the same..

BR

Prabhith

[Former Member]

Hi Satya,

Yes it seems that you may have to disable the primary keys in HANA Tables.

For this you can try the following from HANA Studio

1. Find the table in your Schema.
2. From the Context Menu(Right Click) choose 'Open Definition'
3. Right click anywhere in the definition and select 'Edit'
4. Now you can disable the Primary Key/ Not NULL Constraint

Hope this helps.

--

Shreepad