Following Upgrade from Jira 8.5 to 8.6 Loading Issues Fails with a 500 error

[Ian Logie]

Hi All,

 Please assist;

 After upgrading Jira 8.5 to 8.6 I got a 500 error when accessing an issue.

 With Hipchat enabled (e.g. as the system was post 8.6 upgrade) when entering an issue I get

Technical details

Log's referral number: 860f5fbf-8561-4feb-941c-d9291dc427f4

Cause

Referer URL: http://hyd-ab-tfs01:8085/plugins/servlet/gadgets/ifr?container=atlassian&mid=10001&country=UK&lang=en&view=default&view-params=%7B%22writable%22%3A%22false%22%7D&st=atlassian%3AFVRBHughcsNHNhyGxTpCnort%2B00JfU6ImKrRMMO89BoyU3P7kqDRXC%2BXBlOx7JgU1HuGPEf3bIQrdy4bYdU3owWPHqK4DVEcJqrgTMQfhrlW61O81EjatrymGK0YzKDrM611uSmDLoNGdpH8qfIix%2FUIQtoaGizB62jw4nvlMKkNuEwNyE18lt8alojtps8sMBgTq9T7Xnha%2BV1W6fgqTont97ZyeRAHgEgtxPbSrIJFs%2FU7WmSKuM2p6hLwoTusaptThWLxrZem6zN8FeOEddSZW9bIoiQSEEuWQuEGdfjiC0myebNLlbsCFNd0Lyxga63gHg%3D%3D&up_isConfigured=true&up_isReallyConfigured=true&up_title=Hydrasun+JIRA&up_titleRequired=true&up_numofentries=5&up_refresh=false&up_maxProviderLabelCharacters=50&up_rules=%257B%2522providers%2522%253A%255B%257B%2522provider%2522%253A%2522streams%2522%252C%2522rules%2522%253A%255B%255D%257D%255D%257D&up_renderingContext=&up_keys=&up_itemKeys=&up_username=&url=http%3A%2F%2Fhyd-ab-tfs01%3A8085%2Frest%2Fgadgets%2F1.0%2Fg%2Fcom.atlassian.streams.streams-jira-plugin%3Aactivitystream-gadget%2Fgadgets%2Factivitystream-gadget.xml&libs=auth-refresh

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.base-hipchat-integration-plugin-api]

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.base-hipchat-integration-plugin-api]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:94) [?:?]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:85) [?:?]
	at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38) [?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_202]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
    Database:
    	- name:Microsoft SQL Server
    	- version:13.00.5492
    	- minor version:0
    	- major version:13
    Driver:
    	- name:Microsoft JDBC Driver 7.2 for SQL Server
    	- version:7.2.1.0
    
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "AO_5FB9D7_AOHIP_CHAT_LINK" because it does not exist or you do not have permissions.
	at 

This error suggested this was related to the 3x Hipchat related plugins (

Atlassian Hipchat Integration Plugin, 

Atlassian Hipchat Integration Plugin Core, 

Hipchat for Jira)

which are incompatible with Jira 8.6 according to the Latest Upgrade Report. I disabled each of these and restarted the Jira service.

The upgrade report also lists "some of your user apps have failed to start. They may not be compatible with this version of Jira - Atlassian Universal Plugin Manager - Plugin License Storage plugin."

With the Hipchat plugins disabled I get: -

Technical details

Log's referral number: 7f14ea76-990f-45cc-ac39-b77a75cf88ee

Cause

Referer URL: http://hyd-ab-tfs01:8085/plugins/servlet/gadgets/ifr?container=atlassian&mid=10001&country=UK&lang=en&view=default&view-params=%7B%22writable%22%3A%22false%22%7D&st=atlassian%3Ai7KIFmXgNKvqGgokgwEZyYxSV%2FKn1sM16g3Kl%2B2LAXpTlsjETo08VpaRVTPs2nEx5j8TbF2hD%2F%2BhGH01t4%2B%2FORGLewRY3y9JwykoQm0OwmlmUbXDaDPbbPA18awKWIxOMbn2OswHuw8yuIH9UkGY09FKV1b%2FisjeqTffjMx0rLBYCc0kbPXX9qCJZ96vHEG%2FIpWj3P0zlWBYIFWvLNiXb%2BWieUo7%2BMWJOuzJv7Axl8ZvvEUaPFaVnRLcyM7ygd1o%2BxGGlNZ8lUV4kIrtnuTLer%2Btwn%2FZUOuxwoDrSk%2FNXANd4qcn21FcKieNA8nI7DpP1XkKcg%3D%3D&up_isConfigured=true&up_isReallyConfigured=true&up_title=Hydrasun+JIRA&up_titleRequired=true&up_numofentries=5&up_refresh=false&up_maxProviderLabelCharacters=50&up_rules=%257B%2522providers%2522%253A%255B%257B%2522provider%2522%253A%2522streams%2522%252C%2522rules%2522%253A%255B%255D%257D%255D%257D&up_renderingContext=&up_keys=&up_itemKeys=&up_username=&url=http%3A%2F%2Fhyd-ab-tfs01%3A8085%2Frest%2Fgadgets%2F1.0%2Fg%2Fcom.atlassian.streams.streams-jira-plugin%3Aactivitystream-gadget%2Fgadgets%2Factivitystream-gadget.xml&libs=auth-refresh

com.google.template.soy.tofu.SoyTofuException: In 'print' tag, expression "$sidebarContent" evaluates to undefined.

com.google.template.soy.tofu.SoyTofuException: In 'print' tag, expression "$sidebarContent" evaluates to undefined.
	at JIRA.Issues.Projects.Templates.issueViewWithSidebar(sidebar-issue-navigator.soy:24) [?:?]
	at com.google.template.soy.tofu.internal.BaseTofu.renderMainHelper(BaseTofu.java:369) [?:?]
	at com.google.template.soy.tofu.internal.BaseTofu.renderMain(BaseTofu.java:322) [?:?]
	at com.google.template.soy.tofu.internal.BaseTofu.access$100(BaseTofu.java:66) [?:?]
	at com.google.template.soy.tofu.internal.BaseTofu$RendererImpl.render(BaseTofu.java:476) [?:?]
	at 

[Ian Logie · Accepted solution]

I've resolved this by restoring missing dbo rights for the jiradbuser.

[Raju Adluru]

Great.