Issue can not be opened Error When Trying to Select it in the Issue Navigator
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
Symptoms
When selecting an issue from the Issue Navigator, the following error is displayed:
1
XXX-#### can not be opened. The issue may have been deleted or you might not have permission to see the issue.The following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
2013-01-01 00:00:00,000 http-bio-8080-exec-21 ERROR [500ErrorPage.jsp] Exception caught in 500 page null
java.lang.NullPointerException
at com.atlassian.jira.plugin.viewissue.AttachmentBlockContentRenderingInstructionsProvider.getInstruction(AttachmentBlockContentRenderingInstructionsProvider.java:46)
at com.atlassian.jira.plugin.issuenav.viewissue.webpanel.DefaultContentRenderingInstructionProvider.get(DefaultContentRenderingInstructionProvider.java:39)
at com.atlassian.jira.plugin.issuenav.viewissue.webpanel.WebPanelMapperUtil.mapAndRenderPanels(WebPanelMapperUtil.java:98)
at com.atlassian.jira.plugin.issuenav.viewissue.webpanel.WebPanelMapperUtil.create(WebPanelMapperUtil.java:60)
at com.atlassian.jira.plugin.issuenav.action.IssueAction.populateIssueFields(IssueAction.java:162)
Cause
There's a null value in the created column of the fileattachment table.
You can confirm this with the following query on your JIRA database:
1
select * from fileattachment where created is null;Resolution
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 following update statement on the JIRA database
1update fileattachment set created = getdate() where created is null;Note - for postgres databases run the following update statement on the JIRA database instead of the above
1update fileattachment set created = now() where created is null;Start JIRA
Was this helpful?