After restoring database I get " GreenHopper is currently unavailable. This might be because an upgrade task has failed to run or has not not yet completed. "

[Flacid Snake]

Hi,

I've installed Confluence's database with the same user as Jira's database (great mistake!), so

Jira couldn't start properly. Now the Confluence's database is ok. For Jira, I dropped all the tables and set up them again. Everything's working fine, but I can't make Greenhopper available (I tried to uninstall it and reinstall, but it doesn't work).

Any help?

Thank you!!!

[Flacid Snake · Accepted solution]

What I did in order to solve the problem:
1. Uninstall Greenhopper from the webbrowser interface.
2. Stop Jira
3. Manually locate and delete the AO_60DB71_* tables in my Oracle
Database (using Oracle SQL Developer)
4. Manually locate and delete the AO_60DB71_* sequences in my Oracle
Database (using Oracle SQL Developer)

[ScottC]

Dropping these tables will delete all JIRA agile data. In addition, direct database modification is not supported.

[Flacid Snake]

Logs uploaded!

Any help is appreciated

[Flacid Snake]

https://docs.google.com/file/d/0BypMwk_7iceOMVBTU2xuU2xLMFU/edit?usp=sharing

catalina.out

https://docs.google.com/file/d/0BypMwk_7iceOVzZ1LXNXRkk0cUE/edit?usp=sharing

greenhopper-log

https://docs.google.com/file/d/0BypMwk_7iceOak9tb2t5djVzVDQ/edit?usp=sharing

jira-log

Thank you

[Timothy]

JIRA logs will help.