KB-1803 "Specified key was too long; max key length is 1000 bytes" error seen the application server log when starting Appian

Symptoms

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

Cause

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.

Action

Make sure MySQL has the InnoDB engine by running the following command in MySQL:
 
show engines;
 
Then, set the default storage engine to use InnoDB by running the following command in MySQL:
 
set GLOBAL storage_engine='InnoDb';

Affected Versions

This article applies to all versions of Appian using MySQL as a primary database.

Last Reviewed: November 2018

Related
Recommended