error while loading the FF data in to HANA table.

[Former Member]

Hi I am trying to load FF data in to HANA table which is under a schema, and the load was successful. When i edit the same FF with new entries and try to import to the same existing table ending with the below error. Please help me on same.

Detailed Report

.

User selections Source File:C:\Users\DEMO4\Desktop\FFHANA1.csv Delimiter :COMMA Header Row :1 Target : Table name :RTTAB Schema name :RT01 Store Type :columnstore Table creation RTTAB Data load Mapping Column List CUSNO->CUSNO CUSNAM->CUSNAM REGION->REGION Data load - batch information Batch from record 2 to 5 failed: [301]: unique constraint violated(input position 4) Error Log File C:\Users\DEMO4\hdbkamrul\com.sap.ndb.studio.bi.logs\FFHANA1_RTTAB_1426485224470.csv

Regards,

Ravi

[Former Member]

Hi Ravi,

Can you check if the data in your csv is valid as the exception clearly says that message clearly says that unique key is violated. so your created tables primary key combination should be unique in other words.

Regards,

Nihal