Skip to Content
avatar image
Former Member

Error while loading CSV file

Hello Experts,

I am getting following error while importing CSV file into HANA Database.

I have tried changing the datatype and size of the fields, but then too the load is getting failed.

Could you please suggest me the reason?

Thanks and Regards,

Pragati Gupta

Capture.JPG (45.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 20, 2015 at 10:32 AM

    Hi Pragati,

        I think date format might be incorrect in CSV file. Please convert date into 'YYYY-MM-DD' format in CSV file and then try importing into HANA Database.

    Regards,

    Deepak

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2015 at 10:19 AM

    Hello Pragati,

    I have recreated the issue locally and the errors seems to be that you are using an incorrect datatype against the data being imported. Specifically in this case, it seems to be importing the data into a column of datatype "DATE" but it is not of that format.

    Perhaps, check other datatypes that might be more suitable for importing. Have a look here for more information: https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/a1569875191014b507cf392724b7eb/content.htm#loio20a1569875191014b507cf392724b7eb___csql_data_types_1sql_data_types_introduction_datetime

    If you are satisfied that this solves your issue, please mark the thread as such.

    Thanks.

    Ruaidhri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2015 at 12:04 PM

    Hi Pragati,

    Can you share the table definition in hana and a sample record that you are trying to load?

    Regards,

    Saritha K

    Add comment
    10|10000 characters needed characters exceeded