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
Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch