Unable to delete some issues in Jira Software

[Dheeren Padhey]

Hello,

We have some issues in our project that are not deleting. Due to this, our issue count is also increasing. I have tried it to delete from the admin as well but same result. I have also checked the permissions as well but every thing is ok. After pressing the delete button, getting a big error code, shared a few lines of it below:

Technical details
Log's referral number: 3bc07815-0757-4332-bfee-ddb5312d2306

Cause
Referer URL: https://support.icloudems.com/projects/SIU/queues/custom/42/SIU-11979

com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10105]
com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10105]

Also attached a Screenshot for understanding the issue more clearly.

Thank Yo

[Ravina]

Hi @Dheeren Padhey Welcome to the Atlassian community.

Looking at the error something related to LexoRank and Rank field but need to check the back end application logs for more details,

Try running the integrity check to fix if any database inconstancy that causing this issue and try reproducing this issue on lower instance by refreshing the prod data to lower instance to try the workarounds.

https://confluence.atlassian.com/adminjiraserver/using-the-database-integrity-checker-938847667.html

Also you can check the below documents and check if these queries giving any results

https://confluence.atlassian.com/jirakb/lexorankintegrityexception-expected-exactly-one-rank-row-for-issue-x-for-rank-field-y-but-found-2-rows-1101933359.html

If not found anything create a ticket with Atlassian https://support.atlassian.com providing the support zip file.

Thanks

Ravina