The value supplied cannot be converted to INTEGER

[sivaa_m]

Hi experts,
I m new to Talend. I m currently working on the DW project. Through online tutorial I have learnt how to do mapping using tmap. I need to insert data from the mssql table to another mssql table. From source only four columns need to be inserted into the target table. All are varchar columns. First tried to view the data of the source through tLogRow, while execution I m getting the below error
Exception in component tMSSqlInput_1
java.sql.SQLException: The value supplied cannot be converted to INTEGER.
at net.sourceforge.jtds.jdbc.Support.convert(Support.java:653)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:641)
at edw.psp_dim_0_1.PSP_DIM.tMSSqlInput_1Process(PSP_DIM.java:778)
at edw.psp_dim_0_1.PSP_DIM.runJobInTOS(PSP_DIM.java:1268)
at edw.psp_dim_0_1.PSP_DIM.main(PSP_DIM.java:1136)
As there are no integer column, I could find why this error has occurred. Kindly do the needful. I have attached the screenshot for further use.
Thanks
Siva

[sivaa_m]

hi,
Thanks for the reply. The error has been resolved after changing the select query, but while trying to insert into the target table. I need to apply substring on one of the column which I have mapped like
row1.DB_LOOKUP_PAY_PROVIDER.substring(0,24) in the tmap.
While execution I m getting the below error.
Exception in component tMap_1
java.lang.StringIndexOutOfBoundsException: String index out of range: 24
at java.lang.String.substring(Unknown Source)
at edw.psp_dim_0_1.PSP_DIM.tMSSqlInput_1Process(PSP_DIM.java:1015)
at edw.psp_dim_0_1.PSP_DIM.runJobInTOS(PSP_DIM.java:1460)
at edw.psp_dim_0_1.PSP_DIM.main(PSP_DIM.java:1328)
Kindly suggest.
Thanks
Siva

[Anonymous]

try using the Long data type instead of the Integer. It can handle larger numbers.

[janhess]

That's because your string is less than 24 characters.