error on Importing CSV files into SAP HANA.

[Former Member]

Hi

I am getting java illegalargumentexception error on Importing CSV file into SAP HANA.

the error message is

Batch from record 6002 to 9001 failed

java.lang.IllegalArgumentException

    at java.sql.Date.valueOf(Unknown Source)

    at com.sap.ndb.studio.bi.filedataupload.deploy.populate.PopulateSQLTable.populateTable(PopulateSQLTable.java:93)

    at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.uploadFlatFile(FileUploaderJob.java:199)

    at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.run(FileUploaderJob.java:61)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

The date format in the flat file is (YYYY-MM-DD)

regards

Deepak

[Former Member]

Hi,

As per your information you have All the date formats changed as YYYY-MM-DD. I guess you could check the rows 6001 and 6002 and find what are the additional columns that are added  by comparing these two rows.

Also check for the data type matches and the column count of the CSV file and the Target table.

Srivatsan