Why Do Linked Issues in JIRA Appear with a Strike-Through

Usage FAQ

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

Always back up your data before performing any modification to the database.

JIRA shows linked issues as closed, even though they are open. There are no corresponding error messages found in JIRA's logs. This is caused by issues in the JIRA database having an invalid resolution. The following SQL query can be executed to confirm this:


select pkey, resolution from jiraissue where resolution not in (select id from resolution);

To fix the problem, run this SQL statement and reset the resolution to UNRESOLVED for the issues with invalid resolution.


UPDATE jiraissue SET resolution = NULL where resolution not in (SELECT id FROM resolution);
Last modified on Aug 4, 2010

Was this helpful?

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