Unable to reach Allowlist page or create an AppLink after migrating your Confluence database
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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:
PostgreSQL
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