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
This change was made as part of 16.3 to support replication.
Take a look at the release notes here and the links in that section relating to GTID consistency. There's no way around this, unless you restructure your writes to meet the updated restrictions.