Issues in Epic Field not Rendering

[Bjorn Swenson]

After switching to an SQL server all of the Epics show this in the Epic Links field.

greenhopper-epics-issue-web-panel

Error rendering 'com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel'. Please contact your Jira administrators.

I've followed the steps here and still have the problem.
https://confluence.atlassian.com/jirakb/issue-screen-displays-error-rendering-greenhopper-epics-issue-web-panel-in-jira-server-779158857.html

An Epic with no linked tasks displays as expected. If I add a new epic link to an existing Epic with no links, the issue re-occurs.

[Magic Mike · Accepted solution]

Hi @Bjorn Swenson  what does the integrity checker shows? Any errors ?

[Bjorn Swenson]

Hi Mike,

The integrity checker says everything is ok. I also forgot to mention I've also re-indexed all of the issues

[Bjorn Swenson]

Looking through the Log I can find this error when loading one of those pages

2020-03-01 18:00:16,706-0500 http-nio-8080-exec-19 ERROR Bjorn 1080x2201x1 1rh9d1n 96.127.226.220 /browse/PN-402 [c.a.j.web.component.ModuleWebComponentImpl] An exception occured while rendering the web panel: com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel (null)
com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10005]

[Bjorn Swenson]

FIXED used this solution
https://community.atlassian.com/t5/Jira-Software-questions/Issues-deleting-JIRA-issues/qaq-p/651442