Problem with Mysql -Hour_OF_DATE

[filipesiqueira]

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.

[Anonymous · Accepted solution]

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

[filipesiqueira]

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

Thanks

[Anonymous]

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