When starting up Appian for the first time after a fresh installation, users may see the following error in the application server log:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
The MySQL storage engine was configured to use MyISAM instead of InnoDB as the storage engine. See the MySQL documentation here for further details on storage engines.
set GLOBAL storage_engine='InnoDb';
This article applies to all versions of Appian using MySQL as a primary database.
Last Reviewed: November 2018
© 2020 Appian. All rights reserved.