Received error after entering license key. Previously installed GreenHopper and received this error. After being unable to find any information on this error, uninstalled GreenHopper plugin, ran shutdown.sh and then startup.sh. Error message went away. Installed GreehHopper plugin. Entered license key. Error message started showing up again.
Usually this error relates with a lack of permissions of the user on the database, generating a improperly tables structure and leading to errors like the one that you posted. If this is the case, we'll need to get the structure of GH tables rebuilt.
However, the better way to analyze it and ensure that this is indeed the problem, is upon analyzing the errors on your logs, to provide a better assistance. Then, I kindly ask to you fill a request athttps://support.atlassian.com, on the GreenHopper project and provide all the detailed information, such as error messages and log files. :)
I found errors in logs/catalina.out saying that there were authorization errors when trying to create an index. There were also errors like 'ALTER command denied to user'. Our IT department created the database user id with minimal permissions. The install documentation specifies that you have to grant all access to the jira database. I should have considered that the Jira installation didn't go right for the same reason. It didn't create the indexes either.
I think this can also be caused by restoring data into a JIRA whose Greenhopper plugin is at an earlier version than that of the source JIRA.
In my case I was getting the error importing JIRA OnDemand data into JIRA 5.2.9. The only clue was this line in the logs, indicating that the OnDemand Greenhopper was at version higher than my local JIRA:
Plugin with key 'com.pyxis.greenhopper.jira' and name 'Atlassian GreenHopper' and version '220.127.116.11' is being updated to version '18.104.22.168'.
Moral of the story: when importing from OnDemand, create a blank JIRA, upgrade plugins, then import your data.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Heya, Hipchat friends! We’re so happy you’re checking out Stride. Whether you know it or not, you have been instrumental in making Stride come to life. Every feature, design, and functionality...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs