Hi on linux when i try to create a task i have this error:
INFO o.s.j.s.SQLErrorCodesFactory:126 - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
Could you send me the error log file to email@example.com, the file locates at %MYCOLLAB_HOM%/logs? Thank you.
Th exception is "Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED."
To change to row based binary logging, set the following in /etc/my.cnf (or your my.cnf if it's elsewhere):
Then restart the MySQL server to make the changes effectively. You can see the full description at http://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Thanks a lot, is working now.
Customer support service by UserEcho