Unable to create application links after cloning Jira Server
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
Problem
An application link can't be created after cloning a JIRA instance to another server. Remove an application link from Jira server using SQL does not resolve the issue.
The following appears in the atlassian-jira.log
1
2015-12-04 13:44:23,324 http-nio-8080-exec-11 WARN xxxx xxx xxx xxxx /rest/applinks/3.0/applicationlinkForm/manifest.json [c.a.applinks.core.DefaultApplicationLinkService] Couldn't find type id for application link with id 5d1fd5e9-861e-300a-9412-e0ef36630081. Link is corrupted
Diagnosis
Environment
JIRA
Any other Atlassian application to be linked
Diagnosis Steps
Run the SQL queries below according to your JIRA version
For JIRA 7.0 or newer
1
SELECT * FROM propertyentry pe, propertystring ps WHERE pe.id = ps.id AND pe.property_key = 'applinks.global.application.ids';For JIRA older than 7.0
1
2
3
SELECT * FROM propertyentry pe, propertytext pt WHERE pe.id = pt.id AND pe.property_key = 'applinks.global.application.ids';
SELECT SUBSTR(a.property_key,16,36) as "Application Key", b.propertyvalue as "Application Name" FROM propertyentry a join propertystring b on a.id=b.id where a.property_key like 'applinks.admin%name';You should get a result similar to the below.
1
2
3
4
id | entity_name | entity_id | property_key | propertytype | id | propertyvalue
-------+-----------------+-----------+---------------------------------+--------------+-------+-----------------
12345 | jira.properties | 1 | applinks.global.application.ids | 5 | 12345 | #java.util.List
| | | | | | 5d1fd5e9-861e-300a-9412-e0ef36630081Cause
JIRA database is storing the corrupted Application links ID.
Solution
Workaround
If you get any result from the Diagnosis steps, please follow the rest of the steps below:
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.
Stop JIRA
Run the SQL command below. You will need to modify this SQL statement to contain the id value found in the select query above.
MySQL
1 2 3 4 5 6-- For JIRA 7.0 or newer UPDATE propertystring SET propertyvalue = '#java.util.List\n' WHERE id = '<id-from-select-query>'; -- For JIRA older than 7.0 UPDATE propertytext SET propertyvalue = '#java.util.List\n' WHERE id = '<id-from-select-query>';PostgreSQL
1 2 3 4 5 6-- For JIRA 7.0 or newer UPDATE propertystring SET propertyvalue = E'#java.util.List\n' WHERE id = '<id-from-select-query>'; -- For JIRA older than 7.0 UPDATE propertytext SET propertyvalue = E'#java.util.List\n' WHERE id = '<id-from-select-query>';These queries will clear out all application link IDs. If you're looking to only clear out 1 application link, you'll need to modify the query to exclude the offending applink ID.
Start JIRA.
Was this helpful?