KB-1782 Application server fails with "Halting JVM startup: Administration console migration failed." error during an upgrade or migration

Symptoms

The following error is observed in the application server log after an upgrade or migration:

FATAL com.appiancorp.common.web.StartupHaltingServletContextListener - Halting JVM startup: Administration console migration failed.
com.appiancorp.suiteapi.common.exceptions.AppianException: Administration console migration failed. (APNX-1-4282-000)

Cause

The migration of the primary database cannot be completed for one of the following reasons:

1. The migration has already occurred and is attempting to complete for a second time.
2. The database software/version cannot support the schema. If this is the case, it is likely that the environment is using a database that is not specified in the Appian System Requirements.

In order to determine the exact cause of the issue, the following information is necessary:

1. The exact version and hotfix the environment is being upgraded to and from.
2. The detailed steps followed to complete the upgrade/migration.
3. A SQL dump of the primary database.

Action

1. Gather the above information.
2. Examine the SQL dump of the primary database. Note: As this will likely contain PII, do not upload it to any existing support case. If Appian Support is required to analyze the the SQL dump, it must be examined via WebEx.
3. If it is determined that the database cannot support the schema, ensure that the environment is using a database that is specified in the Appian System Requirements.
4. If it is determined that the migration has previously been performed (e.g. the data that failed to migrate already exists in the database), revert the primary database/environment to a backup taken before the upgrade/migration. Perform the upgrade/migration again and ensure that the data migration is only performed one time.
   1. Additional Context: A SQL dump will contain the SQL statements that should be run in an empty database to regenerate all of the data/tables that existed in the database at the time of the dump. Since the above error "Administration console migration failed." suggests that the migration failed, it would be unexpected to see the SQL statements to update the tables the way a migration would. If the SQL dump does contain these SQL statements, it is likely that the migration has previously been performed.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: November 2018