Hello Atlassian,
We are experiencing an issue with one of the epic ticket. The issues under epic are not visible and give an error "Error rendering 'com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel'. Please contact your JIRA administrators."
With reference to this https://confluence.atlassian.com/jirakb/issue-screen-displays-error-rendering-greenhopper-epics-issue-web-panel-779158857.html document, I was able to delete the corrupted link and the issue got fixed. Later the epic was updated and due to this, it appears new link was corrupted.
I ran this query
SELECT * FROM issuelink il WHERE il.LINKTYPE = ( SELECT id FROM issuelinktype WHERE linkname = 'Epic-Story Link') AND ( il.destination IS NULL OR il.SOURCE IS NULL OR not exists (SELECT null FROM jiraissue ji where ji.id = il.destination) OR not exists (SELECT null FROM jiraissue ji where ji.id = il.source));
Below is the output
id | linktype | source | destination | sequence
--------+----------+---------+-------------+----------
325064 | 10400 | 5948015 | |
Let me know if you need any information. Please guide!