Skip to main content
P
prithvis402624
January 16, 2023
Question

Error Executing SQL while using Import CSV to database v6

  • January 16, 2023
  • 3 replies
  • 0 views

Hi 

While using Import CSV to database, i am facing this issue,

Error message : Error executing SQL.

Can any one help me with the solution
Thanks in Advance

3 replies

S
surjitg0001
January 16, 2023

Hi prithvis,

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

P
prithvis402624Author
January 17, 2023

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.

S
surjitg0001
January 18, 2023

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.

Terms & ConditionsAccessibility statement