You are currently reviewing an older revision of this page.
A Write to Data Store Entity smart service 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 (such as phpMyAdmin, MySQL Workbench,ect...) go to the table where the unknown column exists. Locate 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: July 2018