Jira log file shows error Couldn't find type id for application link with id xxxxxxxx-xxx-xxxx-xxxx-xxxxxxxxxxxx. Link is corrupted
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
Post database restore, errors related to previous application links appear in the logs even though they were deleted from Jira.
The following error appears in the atlassian-jira.log:
1
2
3
myWorkHostChecker:thread-1 WARN [c.a.applinks.core.DefaultApplicationLinkService] Couldn't find type id for application link with id 5053b811-3ed1-3035-9177-fdf2334ca779. Link is corrupted
myWorkHostChecker:thread-1 WARN [c.a.applinks.core.DefaultApplicationLinkService] Couldn't find type id for application link with id e0e876a3-988d-34c0-8b25-b56f8be22bda. Link is corrupted
myWorkHostChecker:thread-1 WARN [c.a.applinks.core.DefaultApplicationLinkService] Couldn't find type id for application link with id 723211d8-95c9-3697-9144-4b1d7112646e. Link is corruptedEnvironment
Jira 8.x.
Diagnosis
The SQL queries below show data related to application links which were previously removed and for which we now see errors in the logs:
1
2
3
4
5
6
7
8
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';
SELECT * FROM propertyentry pe, propertystring ps WHERE pe.id = ps.id AND pe.property_key = 'applinks.global.application.ids';
SELECT * FROM propertystring where propertyvalue like '%application link id here%';
SELECT * FROM propertytext where propertyvalue like '%application link id here%';
SELECT * FROM oauthspconsumer;
SELECT * FROM oauthconsumer;
SELECT * FROM oauthconsumertoken;
SELECT * FROM trustedapp;
Cause
JIRA database is storing the corrupted Application links ID.
Solution
If you get any results 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
Delete the entry(s) that contains the id value found in any of the select queries above.
The delete query(s) should clear out all application link IDs.
Start JIRA.
Verify the errors are not shown anymore in the logs.
Was this helpful?