java.sql.SQLException: Schema change failed on object
While accessing JIRA or Greenhopper, user gets the following error message and is not able to proceed further
java.sql.SQLException: Schema change failed on object '[jiraschema].[AO_60DB71_COLUMN]'. Possibly due to active snapshot or other schema change activity. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:47)
Most likely there is something else running on the database because of which JIRA has problems reading the database.
Please check the database and stop any other service (database replication) or application that is using the same database. It is also recommended to restart the database.