How to update the license key of a third party add-on directly in the Jira Database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
To update the license key of a 3rd party add-on, you need to go to the page ⚙ > Manage Apps > Manage Apps, look for the add-on and paste the new license key there. If for any reason you are unable to update the licence key from this page, please note that it is also possible to directly update it in the Jira Database.
The purpose of this knowledge article is to describe a way to update the license key of a third party add-on directly in the Jira Database using SQL queries.
ℹ️ Please note that this article does not apply to Jira applications such as Jira Software or Jira Service Management. If you need to update the license key of Jira applications via SQL queries, you will need check the following KB article instead: How to manage Jira server license using database queries
Environment
Jira Server/Data Center, on any version from 8.0.0
Solution
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
In the Jira application, go to the page ⚙ > Manage Apps > Manage Apps
Search for the add-on which license key needs to be updated
Expand the add-on, and copy the current license key (you can save it in a temporary text file)
Stop the Jira application
Run the SQL query below (Query 1) to identify the ID of the row that needs to be updated, after replacing <CURRENT_LICENSE_KEY> with the license key you obtained from the previous steps:
1 2 3 4 5SELECT pt.id, pt.propertyvalue FROM "propertyentry" pe INNER JOIN "propertytext" pt ON pe.id = pt.id WHERE pe."property_key" LIKE 'com.atlassian.upm.license.internal.impl.%' and pt."propertyvalue" LIKE '<CURRENT_LICENSE_KEY>';Take note of the ID from the result of the SQL Query 1
⚠️ Make sure to backup the Jira Database before moving on
Run the SQL query below (Query 2) after replacing <ID_FROM_QUERY_1> with the ID identified from Query 1 and <NEW_LICENSE_KEY> with the new license key of the add-on. The purpose of this query is to update the license key of the add-on with the new key.
1 2 3UPDATE propertytext SET propertyvalue = '<NEW_LICENSE_KEY>' WHERE id = '<ID_FROM_QUERY_1>';Start the Jira application
Was this helpful?