XML backup Import issues

Question

I am importing a data from version 4.4 to version 6.4, the DB was built from scratch. I am getting these errors. Please help me resolve the issue.

Technical details
Log's referral number: e5d10672-208d-48a0-970c-90e7d96574fe
Cause
Referer URL: Unknown
java.lang.RuntimeException: org.apache.jasper.JasperException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.base-hipchat-integration-plugin-api]
java.lang.RuntimeException: org.apache.jasper.JasperException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.base-hipchat-integration-plugin-api]
    at com.atlassian.jira.web.pagebuilder.AbstractJspDecorator.writeTemplate(AbstractJspDecorator.java:119)
    at com.atlassian.jira.web.pagebuilder.AbstractJspDecorator.writePreHead(AbstractJspDecorator.java:56)
    at com.atlassian.jira.web.pagebuilder.GeneralJspDecorator.writePreHead(GeneralJspDecorator.java:34)
    at com.atlassian.jira.web.pagebuilder.DefaultPageBuilder.flush(DefaultPageBuilder.java:87)
    at com.atlassian.jira.web.action.Dashboard.doExecute(Dashboard.java:191)
    at webwork.action.ActionSupport.execute(ActionSupport.java:165)
    at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:88)
    at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39)
    at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31)
    at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16)
    at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35)
    at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225)
    at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154)
    at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.atlassian.jira.web.filters.XContentTypeOptionsNoSniffFilter.doFilter(XContentTypeOptionsNoSniffFilter.java:22)
    at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
    at com.atlassian.jira.onboarding.postsetup.ui.PostSetupAnnouncementsFilter.doFilter(PostSetupAnnouncementsFilter.java:61)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
    at com.atlassian.jira.tzdetect.IncludeResourcesFilter.doFilter(IncludeResourcesFilter.java:40)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
    at com.atlassian.jira.baseurl.IncludeResourcesFilter.doFilter(IncludeResourcesFilter.java:38)
    at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
    at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
    at com.atlassian.mywork.client.filter.ServingRequestsFilter.doFilter(ServingRequestsFilter.java:37)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
    at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter.doFilter(PrettyUrlsSiteMeshFixupFilter.java:36)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
    at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
    at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)

Jonas Andersson · Answer

You might be right on that. Our Jira instance uses a plethora of plugins and addons that all had data that needed to be migrated, and some of them failed misserably on the longer version leaps and was the reason i stepped it like this.

Marlon Estipona · Answer

Hi, the existing JIRA we're going to migrate was 3.5. we have successfully migrate the xml data to 4.4.5, we did export from there and imported it to 6.4.

Looks fine so far. the site is up and running. as for plugins, an update is needed in my opinion.

Btw, problem has been fixed by adding REFERENCES grant to the db user we're using.

Jonas Andersson · Answer

Hi,

You can't do this. A 4.4 xml backup will never work in such a new version.

You will have to download 4.4, restore the XML there, update any plugin and addon to latest version then upgrade to maybe 5.0.. I say maybe because the last time i was at 4.4 was a very long time.

A while back i had to upgrade jira 6.2.1 -> 7.1.9, and to achive that i had to go this path:

6.2.1 -> 6.3.15

6.3.15 -> 6.4.13

6.4.13 -> 7.1.9

Reason for this is that so many fundamental changes happened to their database/filesystem between these upgrades, there was NO way to get around it. This upgrade would have taken 6.5 hours, but i managed to get it down to 1.5 hours using these take-aways:

* Don't reindex between the upgrades, wait until you made the last upgrade as this just creates indexes for the UI, ignore that you don't see assigned issues (or issues in general)
* After each upgrade, upgrade all plugins starting with UPM, if anything is incompatible, just disable them till you see a updated version and re-enabled them then.
* Save you dbconfig.xml, cacerts, server.xml, setenv.sh, web.xml and other files that might have been modifed. On each upgrade you will see a bunch of files that are modified. Created folders named after the current version and copy them all there. This allows for a fast fixes once you reached the destination version.
* After all upgrades are done, restore SSL settings, cacerts files. Don't just restore server.xml, but look at both the new files and your original and implement the diffrences.
* Rebuild your indexes.