error while importing .csv file

[hardik_patel]

Hi,

I tried to import  flat .csv file from HANA studio. I follow http://scn.sap.com/docs/DOC-27960

I have HANA Studio with  1.0.29 and HANA Database with 1.0.26.

See the below error:

My Log File:

<status>ERROR</status>

<info>Data Load - Batch Information</info>

<message>

<status>ERROR</status>

<info>Batch from Record 1 to 3401 Failed: [301]: unique constraint violated(input position 482)</info>

<error>com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated(input position 482)

<br/> at com.sap.db.jdbc.CallableStatementSapDB.executeBatch(CallableStatementSapDB.java:681)

<br/> at com.sap.db.jdbc.trace.PreparedStatement.executeBatch(PreparedStatement.java:615)

<br/> at com.sap.ndb.studio.bi.filedataupload.deploy.populate.PopulateSQLTable.populateTable(PopulateSQLTable.java:89)

<br/> at com.sap.ndb.studio.bi.filedataupload.deploy.job.FileUploaderJob.uploadFlatFile(FileUploaderJob.java:186)

<br/> at com.sap.ndb.studio.bi.filedataupload.deploy.job.FileUploaderJob.run(FileUploaderJob.java:59)

<br/> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

<br/></error>

</message>

I am new to HANA Studio and with HANA Database. Can anyone help?

Thanks for your time.

Regards,

Hardik

[hai_murali_here · Accepted solution]

Hi Hardik,

As Rama mentioned,if you are storing the data in Column store table,then you need to make sure that there are no duplicate entries exist for the Primary Key column.

I guess your input file has the duplicate records for the primary column field.Just remove those duplicate records and then try to load.

Rgds,Murali

[Former Member · Accepted solution]

Hi Hardik,

Please take care of data type also.Example date,qty etc

[hardik_patel · Accepted solution]

Thanks to all for your reply. I resolved the issue.

I want to practice with information views and I just have one .csv file. Does any have .csv file that i can use?

regards,

Hardik