Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Type mismatch: cannot convert from int to String

Hi Everyone,
I am facing this error for quite long time even after i double checked my components.
i am using talend 6.1 version while loading data from input tmssql component to output component i am facing error.
even in datatype also i haven't changed anything from source database.
just given guess schema and populated table.
Already i checked datatype of both Database and schema still i am facing this below error:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
    Type mismatch: cannot convert from int to String
    at productionetl.etl_ccagent_0_1.ETL_CCAgent.tMSSqlInput_1Process(ETL_CCAgent.java:2213)
    at productionetl.etl_ccagent_0_1.ETL_CCAgent.runJobInTOS(ETL_CCAgent.java:4634)
    at productionetl.etl_ccagent_0_1.ETL_CCAgent.main(ETL_CCAgent.java:4408)

So somebody could explain me about this error and solve this issue.
Labels (3)
2 Replies
vapukov
Master II
Master II

still good idea - attache screenshot
TRF
Champion II
Champion II

You cannot affect a string from an int.

Use 

String.valueOf(yourNumber)

or

"" + yourNumber