You are currently reviewing an older revision of this page.

DRAFT KB-XXXX REFERENCES command denied to user '<user>'@'<host>' for table '<schema>.<table>'

Symptoms

After upgrading Appian, the application server is unable to start and the following is observed in the application server log:

ERROR liquibase.changelog.ChangeSet - Change Set db-changelog-000168-api-key-table.xml::000168.1.2::appian failed.  Error: REFERENCES command denied to user '<user>'@'<host>' for table '<schema>.<table>' [Failed SQL: ALTER TABLE <schema>.api_key ADD CONSTRAINT api_key_usrid_fk FOREIGN KEY (usr_id) REFERENCES <schema>.<table> (id)

Cause

The REFERENCES permission might have changed due to a possible database upgrade (application version upgrade).

Action

  1. Stop the application server.
  2. Execute the following query on the database:
GRANT REFERENCES ON <schema>.<table> TO '<user>'@'<host>';
  1. Start the application server.
  2. If the same error is thrown for another table, repeat steps 1-3.

Affected Versions

This article applies to all versions of Appian.

Last reviewed: August 2019