Epic Error rendering 'com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel'.

[Deepali Bagul]

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!

[Andy Heinzer]

The steps in the resolution are to delete these invalid links.  And it sounds like you have done that at least once already.   Since you are still getting some results back with that SQL select statement, this indicates that you still have some process that is creating these invalid links OR you have not removed all of them yet (or both).

Have you also walked through using the Using the database integrity checker as indicated in that KB yet?   Did this turn up any problems?  

Do you have any 3rd party plugins in jira that might be creating issue links or epic links via a post function?  The KB mentions that there have been some plugins such as the Jira Suite Utilities that could have been configured in this manner.   If so, this could be the source of the problem.

[Deepali Bagul]

Hello @Andy Heinzer

I already deleted the all the invalid links ( we had 2 invalid links), and this resolve the issue. But very next day the new invalid link was created. I am trying to find out what is the real cause behind this. We are experiencing this issue only with one specific epic.  We never had this problem in past and all other epics are working well, nothing was changed in workflow postfuntions.

I tried using database integrity checker, but this is giving me the timeout error.

We are using Jira Suite utilities plugin, Below is the screenshot of postfunctions on Create issue. But this was not changed since last two months and we started seeing the epic issue last week

Please help!

Thanks,

Deepali

[Andy Heinzer]

Well, those appear to be a lot of post functions for the create transition.   However it might also help to examine all the other transitions that can exist here for both the epic issues and the issues in those epics.  

Something appears to be creating invalid epic links.  But figuring out exactly which process is doing this could be very difficult to identify.

In regards to using the integrity checker, if you are getting a timeout when trying to use this, then you might just try to run each individual check one at a time in order to see if you can complete each of these correctly.

If that doesn't help, then the next steps could be to try to use an unproxied connector to Jira.  Usually when these timeouts happen, it is because Jira is behind a reverse proxy and it is the proxy that reaches a timeout before Jira actually does.  By avoiding the proxy, you can usually complete these checks directly in your browser.  Steps on how to do that are in How to bypass a Proxy and SSL to test network connectivity.

The other way to try to troubleshoot this issue would be to disable user plugins until you can no longer recreate this problem.  However if this is a production instance of Jira, that might cause more problems in terms of other users actually being able to use Jira as they intend.  In which case, problems like this might be better tested in a staging environment.

[Deepali Bagul]

Thanks @Andy Heinzer

I was able to remove the invalid links through integrity checker. I still couldn't figure out what is the reason the links are getting created. this is 3rd time it got created. Well, I do have a temporary solution. I shall try working with the disabling plugin in staging and see if that is the caused.

Regards,

Deepali Bagul