DBS-070401 : Error loading to Hana target table

[former_member428214]

Hi All,

I am loading data from Oracle staging table to HANA and got the below error ...

Dataflow DF_HANA_test|HANA_TS

  ODBC data source <HANA DS DEV> error message for operation <SQLExecute>: <[SAP AG][O][HDBODBC] Integrity constraint

  violation;301 unique constraint violated>.

we had no issues when loading into the staging table, but getting this when updating into final hana target..

the Primary keys are same as the staging table...

thanks

sam

[aasavaribhave]

what version of DS is it? Are you using hierarchy flattening transform? Bulk load? Also, please ensure that there are really no duplicate PKs in source

[former_member428214]

Hi.

DS4.2 is the version and there is no hierarchy flattening transform but yes BULK load is enabled with truncate option for hana target table.

Its just plain 1-1 mapping with single query transform in DF

There are no duplicate primary keys...

My biggest doubt is when the data is able to get updated into the staging table from source but not to the target table which has the same structure and PK's....