Troubleshooting
Problem
When starting the IBM Application Center running on MySQL errors regarding BINLOG_FORMAT may occur.
Symptom
The WebSphere system out logs for the WorkLight server will show the following message on startup. Preventing you to access the console and your Maximo Anywhere applications.
Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: 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.
Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: 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.
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSPJLC","label":"Maximo Anywhere"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.0;7.6.1;7.6.2;7.6.2.1;7.6.3;7.6.3.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 November 2019
UID
swg21695572