Error Executing SQL while using Import CSV to database v6

Hi prithvi,

Please check the System Log -> tomcat-stdOut.log for the smart service/plugin , that may give you some detailed error message. From the error it seems there is some configuration issues in the data section of the smart service, check the field properties if configured correctly.

Regards,

Surjit

Hey thanks man, error message from system log helped me to solve the issue, actually its because of the length of the field.
I have increased the length and its working.
But now another issue came up, 

java.lang.NumberFormatException: For input string."100000000394793"

the number above is the number from the csv file from the first line.
FYI smart service is working for the other file actually, and these two files are similar one
do you have any idea on this.
Thanks.

Hey thanks man, error message from system log helped me to solve the issue, actually its because of the length of the field.
I have increased the length and its working.
But now another issue came up, 

java.lang.NumberFormatException: For input string."100000000394793"

the number above is the number from the csv file from the first line.
FYI smart service is working for the other file actually, and these two files are similar one
do you have any idea on this.
Thanks.

it seems it is not able to parse the content from excel to integer/number. Are there trailing or leading spaces. Check the data types in table field. I would prefer to change that to text for easy parsing.