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

One Star

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

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
One Star

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

Recently fixed, see 1195
One Star

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

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
Employee

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

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,
One Star

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

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

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

This RC1 is for all OS.
One Star

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

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,
Employee

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

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)
One Star

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

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

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

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.
One Star

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

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
Four Stars

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

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