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


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. 

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: April 2018