Error after upgrading from 6.4 to 7.0

[Brian Reimer]

Hello, as part of our migration from Server to Cloud I am in the process of upgradding server from 6.4 to 7.0. The upgrade said it completed succesfully and I was initially able to login and see the page with new enhancements in 7. However, when I click ok I recieved a 500 error and the below details. I can provide additonal logs if needed.

Technical details

Log's referral number: c92f41c2-6b78-4c27-95b2-cadb88eec7a3

Cause

Referer URL: http://localhost:8080/secure/Dashboard.jspa

com.atlassian.cache.CacheException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.pyxis.greenhopper.jira]

[Daniel Ebers]

Hi @Brian Reimer

it seems there is a knowledgebase article which touches the error message at least:

• Action in Jira server fails with Could not find column in previously parsed query error in log
  https://confluence.atlassian.com/jirakb/action-in-jira-server-fails-with-could-not-find-column-in-previously-parsed-query-error-in-log-315326688.html

Please note this is of rather a long shot as Community members cannot not know the actual infrastructure on your end.
It would be needed to further inspect the database and the installation - a start could be the points listed in the knowledgebase article.

Regards,
Daniel

[Brian Reimer]

I figured it out, it was related to an entry created by an addon.  

[Daniel Ebers]

I see, glad you were able to fix it. Addons can be a culprit, useful as they are - sometimes they can show unintended behaviour, especially during/right after upgrades.

[Brian Reimer]

Additonal detail from logs 

Caused by: java.lang.IllegalStateException: Could not find column 'LONG_QUERY' in previously parsed query!
 at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:120) [?:?]
 at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:139) [?:?]
 at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:122) [?:?]
 at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:60) [?:?]
 at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:110) [?:?]
 at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:107) [?:?]