CCMA should have a pre-check to confirm database schema configurations

Details

In the Confluence server, if the Confluence database user does not have appropriate access to the schema being used by Confluence, the CCMA app cannot be enabled and will display this error:

The app failed to enable. Refer to the logs for more information.

If you examine the atlassian-confluence.log file, you will see an error reference like this one:

Caused by: liquibase.exception.DatabaseException: The default schema does not exist. [Failed SQL: (2797)

This suggestion is for a better pre-check and on-screen error message to identify potential database schema configuration issues.

Workaround

When SQL Server is being used, follow the steps in this guide:

• Database Setup for SQL Server

Specifically, this step:

Give this user the default schema as follows:

ALTER USER <confluenceuser> WITH DEFAULT_SCHEMA = dbo