How to view a previous sprint that has been closed?

[Brian Cooper]

In board view.....

In next gen project. 

I have no sprint report, if that helps to know which version I am using. 

[Renjith Pillai · Accepted solution]

Is this issue resolved?

Is the custom field id 12910 the Rank custom field of GreenHopper? If yes, the ranking data is corrupted. You need to fix up the database.

[Pushpkant]

Hi Renjith,

The custom field 12910 is Rank custom field of GreenHopper. Can you please tell how can I fix the database.

Thanks,

Pushpkant Garg

[Pushpkant]

Thanks Renjith.. I will not be executing any DML statements before taking backup of the tables.

Also I will raise the Support ticket with Atlassian.

Thanks for your help.

[Renjith Pillai]

It's a bit lengthy process, I would suggest that you raise a support request so that they can help you to get rid of the duplicate rows from the RANK tables of GreenHopper. The table is "AO_60DB71_ISSUERANKING" which you also can check. But be careful with deletion, make a backup of the database before attempting anything.

[John Chin]

Hi there,

I suspect there is some corruption data happen in JIRa instance, would you mind to perform the following steps to rebuild the file again?

1. Shut down JIRA
2. Remove jira-home/caches/indexes directory
3. Remove jira-install/work directory
4. Restart JIRA and Re-index

[Pushpkant]

Hi John,

The above ateps didn't helped me. Can you please suggest something else which will resolve our problem.

Thanks,

Pushpkant Garg

[Prakash Ganeshan]

Hi Pushpkant, I am also facing this error. Were you able to get fix the issue ? If yes, please let me know the steps to fix this issue.