Error making entry in table au_transaction data

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
Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    David Paras

    The solution can also be applied to this error

     

    java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

Article is closed for comments.