flat file error

[former_member207019]

Dear Team,

I am trying to upload the data from csv format. I have changed date format as "yyyy-mm-dd" and time format "hh:mm:ss".

While importing i have changed data type from nvarchar to Date and Time respectively.

I am getting the below issue.

Message :

Batch from record 2 to 506 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)

Regards,

Jo

[lbreddemann · Accepted solution]

Sounds like the data format got corrupted.

Maybe you can post the first few lines of the file so that we can see what might be wrong with it.

[former_member207019 · Accepted solution]

Could you please kindly provide information on how to handle the DATE, Time,UNIT and Currenncy, currency fields from flat file loading.

[former_member207019 · Accepted solution]

There was date and time format issue. It is resolved.