Found this link which seems to detail the issue we're facing so we truncated the Lexorank DB then dropped and re-added. Restarted Jira ok but the LexoRank system page does not show any administrstion buttons, just this message:

The LexoRank system is part of JIRA Software. If you have never used JIRA Software before, you won't need to configure anything on this screen. Otherwise, you can manage the ordering of issues via this screen, but we recommend that you contact our support team before doing so.

Also found this link but following steps there and reindexing made no difference.

And tailing the catalina.out log while moving an issue we see the following:

1 answer

Sorry to hear there are SQL exception here. Given the steps you have followed so far, I would like to confirm what data exists in your database right now. It sounds like your problem is similar to that of https://jira.atlassian.com/browse/JSWSERVER-10975

From that page there are steps to follow to make sure this is setup correctly. Specifically I am interested to see the results of step #3 and then learn if you formatted the insert statements as such: