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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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