Team, I am beginner to TOS DI, I am facing the below error and i couldn't find the root cause. Please help me out. Thanks in Advance. Exception in component tPostgresqlInput_1 org.postgresql.util.PSQLException: Bad value for type Float: f:371 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toBigDecimal(AbstractJdbc2ResultSet.java:2756) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBigDecimal(AbstractJdbc2ResultSet.java:2177) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBigDecimal(AbstractJdbc2ResultSet.java:325) at local_project.investor_funds_0_1.investor_funds.tPostgresqlInput_1Process(investor_funds.java:3294) at local_project.investor_funds_0_1.investor_funds.runJobInTOS(investor_funds.java:5773) at local_project.investor_funds_0_1.investor_funds.main(investor_funds.java:5630)
Compare schema of Your input component and real data coming from select,
it must be:
- same name
- same order
- same type
Talend not analyse name of columns, it trust You - what You show in schema, exactly this coming from database (text file and etc)
and easy in float column could be not float value
