EXCEPTION (value supplied cannot be converted to DECIMAL)

Four Stars

EXCEPTION (value supplied cannot be converted to DECIMAL)

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
One Star

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

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
Four Stars

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

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
One Star

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

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 Smiley Happy
Regards,
Arno
One Star

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

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