KB-XXXX Specified key was too long; max key length is 1000 bytes

Symptoms

When starting up Appian for the first time after a fresh installation, users may see the following error:

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.

Make sure MySQL has the InnoDB engine. Then set the default storage engine to use InnoDB by running the following command in MySQL:

set GLOBAL storage_engine='InnoDb';

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

Last Reviewed: November 2018