The write to Multiple Data Store node was working fine on Appian 16.2, after upgrade , it is failing.
Error : Caused by: java.sql.SQLException: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
The writes happening in the node to two tables , both are tables and none of them is temp table.
There is no configuration on Write to Data to Store node to indicate - transactions or non transnational ?
Please advice.
Discussion posts and replies are publicly visible