Problem

- If B2Bi/Interchange is not retriving files anymore, TE is started and you can access to B2Bi GUI.

- Also, you have the following error on cn.log on /Interchange/logs:

2017-12-04 11:48:14,240 - ERROR [Startup] (DefaultRegistryManager.removeEntry:503) - Error removing the database entry for node vshfw007_cn

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.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)

Resolution

- Run this query to check the value of binlog_format variable

show variables;

If it is STATEMENT, then run the following queries, while the product is stopped.

SET GLOBAL BINLOG_FORMAT= 'ROW' ;

SET SESSION binlog_format = 'ROW';

Start the product and make sure the modification has been taken into account.