topic Re: Bad value for type Float Error in Talend Studio

Bad value for type Float Error

Anonymous — Fri, 14 Oct 2016 06:45:41 GMT

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)

Re: Bad value for type Float Error

vapukov — Fri, 14 Oct 2016 08:50:10 GMT

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

Re: Bad value for type Float Error

Anonymous — Fri, 14 Oct 2016 12:46:48 GMT

Thanks for the solution. Working Perfect