Cannot find "external_id" column when trying to upgrade to a Confluence CDC license after upgrading from a pre-5.5 Confluence Clustered installation

Still need help?

The Atlassian Community is here for you.

Ask the community

This article applies to Confluence Data Center 5.6 or later.


When upgrading from pre-5.5 Confluence Clustered installation to Confluence Data Center 5.6 or higher, you will be told that 

Your current license is for the old Cluster edition of Confluence and is not valid with Confluence Data Center edition

When you visit Confluence with the browser to fix the license, you an error message along the following lines:

ERROR: column this.external_id does not exist
ORA-00904: "THIS"."EXTERNAL_ID": invalid identifier


Due to changes in how Confluence Data Center licenses work, the upgrade from the old cluster license will sometimes fail depending on the login state of the admin user performing the upgrade. Specifically, if the user has their remember-me cookie present when they go to enter the new license, then the error will occur.


Clear the seraph.confluence browser cookie related to the Confluence server being upgraded. You can either do this before the upgrade starts, or after you get the above error. If you get the error before clearing the cookie, then just refresh the page, and you should then be presented with a screen allowing you to enter the Data Center license.

Last modified on Feb 26, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.