KB-1526 "Unknown database '[database_name]'" error thrown during JBoss startup

Symptoms

The following error is thrown during JBoss startup:

12:14:45,984 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (ServerService Thread Pool -- 70) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database '<database_name>'
...

JBoss ultimately fails to start up.

Cause

The Appian data source defined in appian-ds.xml references a schema that does not exist in the database.

Action

To correct this issue, perform the following:

1. Stop JBoss.
2. Perform one of the following:
   • Rename the schema in the database server to match what is set in appian-ds.xml.
   • For new installations of Appian, create a new database schema with the name set in appian-ds.xml.
   • Update appian-ds.xml to point to the correct schema in your database.
3. Restart JBoss.

Affected Versions

This article applies to all versions of Appian using JBoss as an application server.

Last Reviewed: March 2018