DRAFT KB-XXXX Tomcat fails to load with "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version"

Symptoms

Tomcat fails to start with the following error:

ERROR org.hibernate.util.JDBCExceptionReporter - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system, url_alias, uuid, version_uuid) values (X, XXXXXXXXXXXX, X, XXXXXXXXXXXX' at line 1
...
INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Appian data source: jdbc/AppianDS DataSourceMetadata[databaseProductName =MySQL, databaseProductVersion=X.X.XX, driverName=MySQL Connector Java, driverVersion=mysql-connector-java-X.X.XX ( Revision:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX )]

Cause

Tomcat will return this error when the environment is using an unsupported version of MySQL.

Action

Refer to the System Requirements documentation to determine the supported versions of MySQL and upgrade MySQL accordingly.

Affected Versions

This article applies to Appian 18.3 and later.

Last Reviewed: October 2018.