You are currently reviewing an older revision of this page.
A process model fails when it gets to the writes to database node. The error thrown is:
java.sql.BatchUpdateException: Unknown column 'X' in 'field list': com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'X' in 'field list' Data
When data is written to the database there is a trigger that also inserts content into a secondary database. The reason that the application server throws error is because the secondary database doesn't include column X
In phpMyAdmin go to the table wher
This article applies to all versions of Appian.
Last Reviewed: April 2018