Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

getting exception during 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 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

Any help appreciated

lots of hardcore big-boob fucking videos here https://bigtitstube.xxx/

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@hurleigh , you cannot convert into BIGDECIMAL ,may be you need to use Long or Double in the data type of tmssqlinput.