topic Re: EXCEPTION (value supplied cannot be converted to DECIMAL) in Talend Studio

EXCEPTION (value supplied cannot be converted to DECIMAL)

Anonymous — Sat, 16 Nov 2024 12:27:38 GMT

Hi All
-> I am getting exception during my transformation.
Exception in component tMSSqlInput_1
java.sql.SQLException: The value supplied cannot be converted to DECIMAL.
at net.sourceforge.jtds.jdbc.Support.convert(Support.java:653)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getBigDecimal(JtdsResultSet.java:1024)
my input data is :
16179.96 161.80 16018.16
-2922.73 0.00 -2922.73
-6.00 0.00 -6.00
385.60 0.00 385.60
30131.38 0.00 30131.38

and my data type is BigDecimal for all the three columns in talend and my sql server database datatype is Numeric
Any help appreciated

____________________________________________________________________________________________
tHANKS
ANIL KUMAR

Re: EXCEPTION (value supplied cannot be converted to DECIMAL)

Anonymous — Thu, 12 Jan 2012 09:19:12 GMT

Hi,
Maybe a screenshot would help to determine where exactly something is going wrong.
Also line 3920 of the generated code can tell you a lot more about what column/value Talend is complaining about.
Regards,
Arno

Re: EXCEPTION (value supplied cannot be converted to DECIMAL)

Anonymous — Thu, 12 Jan 2012 09:40:17 GMT

my input data contain 3 columns with value :

16179.96 161.80 16018.16
-2922.73 0.00 -2922.73
-6.00 0.00 -6.00
385.60 0.00 385.60
30131.38 0.00 30131.38
transformation from sqlserver to sqlserver in sqlserver DB schema is Numeric but during importing data while during transformation we are taking BigDecimal as data type in Type on tmysqlinput and DBType in Numeric
thanks
Anil

Re: EXCEPTION (value supplied cannot be converted to DECIMAL)

Anonymous — Thu, 12 Jan 2012 10:03:28 GMT

Hi,
Yes, input data is clear, it's just that Talend complains about 1 value. This can be found on line 3920 of the generated code.
Also: a screenshot of the job would probably help
Regards,
Arno

Re: EXCEPTION (value supplied cannot be converted to DECIMAL)

Anonymous — Tue, 24 Mar 2015 16:15:31 GMT

Try changing "." by "," in data, in sql server that is defined by the database locale or a nonvisible character