Error java.sql.SQLDataException: [Amazon][JDBC](10400) Invalid type for data - column: 20, type: int.

[Sging]

Hello,

I have a job that connects to Redshift Database and runs some queries and exports some files to s3 bucket (see image of failing component) .

Error message upon first run after building :

java.sql.SQLDataException: [Amazon][JDBC](10400) Invalid type for data - column: 20, type: int.

Inside the failing component I am just truncating and inserting data into 2 tables. Code in the failing components runs correctly I checked.

Talend Open Studio for Data Integration v7.3.1 .

OS: Windows

Thanks in advance

[Anonymous]

Hi

Please check if the number of columns on the schema map the select fields in the query, and check if each column has the right data type.

Regards

Shong

[Sging]

You are right error was fixed after applying this! Thanks !