topic Re: Problem with Mysql -Hour_OF_DATE in Talend Studio

Problem with Mysql -Hour_OF_DATE

filipesiqueira — Tue, 23 Mar 2021 20:32:39 GMT

Hi, i am with a problem at job, i try to read data of mysql and my process start and stop at 52220 line with this error

java.lang.IllegalArgumentException: HOUR_OF_DAY: 0 >0

I post a image of print of error below to help, my ETL process is to extract data of Progress and to load of Mysql, after this, i realize a extract of mysql of the same data to load at other database with some transformation, but when i start the job to read data of TDBOUTPUT MYSQL TO TLOG_ROW, give this error at line 522220 and stop the process, i have many data fields in this database, but whe i remove this fields and load the job with the other fields tha contain ih this table with data type varchar, the process execute with success, but when i input the field data, appear this error of HOUR_OF_DAY

Could help me please.

Re: Problem with Mysql -Hour_OF_DATE

Anonymous — Wed, 24 Mar 2021 09:08:41 GMT

Hello,

What's MySQL version are you using? jdbc6? Did you try to set severTimezone

in mysql to see if it works?

Best regards

Sabrina

Re: Problem with Mysql -Hour_OF_DATE

filipesiqueira — Wed, 24 Mar 2021 16:15:32 GMT

solved the problem, the version that was use in MySQL is 8, i adjuste to version 5 and the job executed.

Thanks

Re: Problem with Mysql -Hour_OF_DATE

Anonymous — Thu, 25 Mar 2021 07:34:10 GMT

Hello,

You could try to set severTimezone in Mysql 8 to see if it works.

Thanks for your update and letting us know you have resolved your issue.

Best regards

Sabrina