You are currently reviewing an older revision of this page.

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

 

Symptoms

A process model fails when it gets to the write 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. 

Cause

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

Action

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