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
However, when you check the table of the unknown column exists.
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 where the unknown column exits. Go to the Triggers tab and verify that the secondary table you are updating contains column X.
This article applies to all versions of Appian.
Last Reviewed: April 2018