topic Re: error message : Cannot convert value '0000-00-00' in Talend Studio

error message : Cannot convert value '0000-00-00'

Anonymous — Sat, 16 Nov 2024 14:35:52 GMT

Hey everybody! can you help me?.
I have a problem with tmysqlinput, if I want to load data from input table to output table, I got message error. The message was like this
?Cannot convert value '0000-00-00' from column 8 to TIMESTAMP?
Thanks a lot for your information

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Mon, 18 Jun 2007 10:51:52 GMT

Recently fixed, see 1195

Re: error message : Cannot convert value '0000-00-00'

_AnonymousUser — Fri, 06 Jul 2007 02:56:06 GMT

hai ...
I still doesn't understand. What must i do if i found this case...
thx
i'm already user talend version 2.0.3 and use java language. i'm already see bugtacker. can u help me to explain what must i do?

Manda

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Fri, 06 Jul 2007 11:26:29 GMT

Hello,
As you can see in the bug properties, it has been Fixed in Version 2.1.0M2.
Either you update to last testing version of 2.1 (2.1RC1 is currently available), either you wait for 2.1 final release.
Regards,

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Fri, 06 Jul 2007 13:52:19 GMT

And where's RC1 for linux ?!?!?

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Fri, 06 Jul 2007 15:23:23 GMT

This RC1 is for all OS.

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Mon, 09 Jul 2007 13:47:45 GMT

Then you should had the linux icon next to it in the Download Page cause currently, it looks like it's for Windows Only.
Thanks,

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Mon, 09 Jul 2007 14:03:57 GMT

Then you should had the linux icon next to it in the Download Page cause currently, it looks like it's for Windows Only.

job's done (by ocarbone)

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Mon, 09 Jul 2007 15:00:49 GMT

And rename it some like TOS-ALL-V2.1.0RC1 instead of TOS-Win32-V2.1.0RC1.
hehe

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Mon, 28 Sep 2009 15:45:54 GMT

hi ,
i got the Same execption in TOS-All-r26090-V3.1.3.

Exception in component tMysqlInput_1
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6678)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5845)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5645)
at zwh.dsa_0_1.dsa.tMysqlInput_1Process(dsa.java:2715)
at zwh.dsa_0_1.dsa.runJobInTOS(dsa.java:3623)
at zwh.dsa_0_1.dsa.main(dsa.java:3412)

please provide solution for this.

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Thu, 22 May 2014 17:51:55 GMT

Hi, I got this today too
Exception in component tMysqlInput_1
java.sql.SQLException: Cannot convert value '2014' from column 8 to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1363)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:576)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6591)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6191)
at natcobidw.dlisting_1_0.dListing.tMysqlInput_1Process(dListing.java:2714)
at natcobidw.dlisting_1_0.dListing.tMysqlRow_1Process(dListing.java:472)
at natcobidw.dlisting_1_0.dListing.runJobInTOS(dListing.java:4472)
at natcobidw.dlisting_1_0.dListing.main(dListing.java:4337)
Caused by: java.lang.NumberFormatException: 548403012011912013-11-12 06:26:19

Re: error message : Cannot convert value '0000-00-00'

Anonymous — Fri, 23 May 2014 04:55:33 GMT

It is number format exception....
Can you show your input format and value in your column 8?
What timestamp value you set in metadata for column 8?
Vaibhav