Summary

After migrating your Confluence instance and your Confluence database to a new hardware, the application link can not be created

Environment

Confluence 7.12

Diagnosis

In the atlassian-confluence.log  files, the following exception can be observed while trying to create an application link by using OAuth authentication type:

Caused by
java.util.concurrent.CompletionException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.atlassian-whitelist-core-plugin]
at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(Unknown Source)
caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.atlassian-whitelist-core-plugin]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)
caused by: java.lang.IllegalStateException: Could not find column 'AUTHENTICATIONREQUIRED' in previously parsed query!
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:120)

This error implies that the AUTHENTICATIONREQUIRED column is missing on table AO_21D670_WHITELIST_RULES .

Cause

The root cause of this error is unknown.  Our current assumption is that this issue is triggered by missing steps/procedure when migrating the Confluence database. 
When we have clear reproduction steps, we will update this KB article accordingly.

Solution

You can add column AUTHENTICATIONREQUIRED to the table AO_21D670_WHITELIST_RULES by using the below steps:

 1. Stop Confluence
 2. Execute the below query against your Confluence database:

ALTER TABLE AO_21D670_WHITELIST_RULES ADD COLUMN "AUTHENTICATIONREQUIRED" tinyint(1) DEFAULT 0 NOT NULL;

 3. Start Confluence
 4. Once completed, try to create application link between Jira and Confluence