Error:
I tried to trigger an event and execute a process flow and the Adeptia interface shows that the trigger executed successfully, but nothing is processed. Here is what is shown in the Kernel Logs -
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.
Cause:
The MySQL log database is not configured correctly.
Solution:
Adding the following entry to the my.ini file
binlog_format=row
Comments
1 comment
The solution can also be applied to this error
Article is closed for comments.