Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
solved the problem, the version that was use in MySQL is 8, i adjuste to version 5 and the job executed.
Thanks
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