You are currently reviewing an older revision of this page.

KB-XXXX Unknown column 'X' in 'field list' 'Data' Error



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



Affected Versions

This article applies to all versions of Appian.

Last Reviewed: April 2018