You are currently reviewing an older revision of this page.
A Write to Data Store Entity smart service (link to the docs here) fails and errors out in the application server with:
java.sql.BatchUpdateException: Unknown column 'X' in 'example': com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'X' in 'field list' Data
When checking the table, the column in the error exists.
A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Since triggers are event-driven specialized procedures, they are stored in and managed by the RDBMS. If the database has a trigger configured to write the data to a secondary table then verify that the column exist. The error is thrown because the secondary table doesn't include the column mentioned in the error message.
In the database administration tool go to the table where the unknown column exits. Go to the location where trigger and established and verify that the secondary table you are updating contains column X.
This article applies to all versions of Appian.
Last Reviewed: April 2018