Could not parse column as timestamp

Anonymous — Mon, 21 Aug 2017 15:54:32 GMT

Hello,

I need your help in this issue

I have a talend job which load data from a table to another with a simple tmap.

I called it a mysterious error because it happended just for a specific datetimes

java.sql.SQLException: Could not parse column as timestamp, was: "2009-06-01 00:00:00"

Thousands of rows before the row containing this line doesn't generate the error

When I modify this date 2009-06-01 00:00:00 to another or just changing the day part or the month or even the hour, It goes without error.

the datasource is a mariadb and the destination is a Mysql database

the field is a datetime in the source database and the destination too.

thnks for your help

Re: Could not parse column as timestamp

Anonymous — Mon, 28 Aug 2017 04:21:30 GMT

Hello,

Could you please also indicate on which talend build version you got this issue?

Best regards

Sabrina

Anonymous — Mon, 28 Aug 2017 09:13:25 GMT

Hello,

I had the same error in 6.3 and 6.4 (TOS DI)

Thnks

Badr