Importing xml backup from HSQLDB into new SQL Server 2008 DB - Import stuck at 90%?

I am running the import but it looks like it is stuck at 90% for the last 30 minutes.  It was a small xml file to begin with activeobjects.xml being 128KB and entities 2075kb - has this crashed or how can i check - is there any log file?

3 answers

This widget could not be displayed.

Ok found a log file and there was nothing happening so looks like it hung so stopped it - then stopped jira server but now the service won't start again!

This widget could not be displayed.

However, there are issues missing from backlogs and boards - so there must have been an issue with the install - here are the details from the logs - any ideas - do I need to re-import - also it is giving a message on indexing 2015-03-12 05:47:52,161 JiraImportTaskExecutionThread-1 INFO anonymous 347x93x1 7xttoo 10.92.96.167 /secure/SetupImport.jspa [atlassian.plugin.manager.DefaultPluginManager] Shutting down the plugin system 2015-03-12 05:47:52,505 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [greenhopper.service.logging.LogSupport] ********************************************************************************* Atlassian GreenHopper v6.3.13.1 #a73d75f118867c66 built 2014-05-07T21:52:18.123-06:00 - plugin stopping... ********************************************************************************* 2015-03-12 05:47:52,520 Timer-3 WARN anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.greenhopper.service.BridgeServiceLocator] The GreenHopper BridgeServiceLocator has been unwired and is no longer usable 2015-03-12 05:47:52,520 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [greenhopper.service.logging.LogSupport] ********************************************************************************* Atlassian GreenHopper v6.3.13.1 #a73d75f118867c66 built 2014-05-07T21:52:18.123-06:00 - plugin stopped ********************************************************************************* 2015-03-12 05:47:54,735 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [plugins.dvcs.listener.DvcsAddUserListener] Attempting to unregister listener ... 2015-03-12 05:47:54,735 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [plugins.dvcs.listener.DvcsAddUserListener] Listener unregistered ... 2015-03-12 05:47:54,751 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [plugins.dvcs.scheduler.DvcsScheduler] DvcsScheduler job handler unregistered 2015-03-12 05:47:56,264 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [jira.plugins.monitor.MonitoringScheduler] Unscheduling metrics collector... 2015-03-12 05:47:56,264 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [jira.plugins.monitor.MonitorLauncher] Stopped JIRA monitoring 2015-03-12 05:47:56,436 Timer-3 ERROR anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.event.internal.AsynchronousAbleEventDispatcher] There was an exception thrown trying to dispatch event '[com.atlassian.plugin.event.events.PluginModuleUnavailableEvent@7b87c01c, SingleParameterMethodListenerInvoker{method=public void com.atlassian.plugin.manager.DefaultPluginManager.onPluginModuleUnavailable(com.atlassian.plugin.event.events.PluginModuleUnavailableEvent), listener=com.atlassian.jira.plugin.JiraPluginManager@35787ffa}]' from the invoker 'java.lang.RuntimeException: service proxy has been destroyed' 2015-03-12 05:47:58,479 FelixStartLevel ERROR anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.plugin.module.PrefixDelegatingModuleFactory] Detected an error instantiating the module via Spring. This usually means that you haven't created a <component-import> for the interface you're trying to use. https://developer.atlassian.com/x/TAEr for more details. 2015-03-12 05:47:58,479 FelixStartLevel ERROR anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.event.internal.AsynchronousAbleEventDispatcher] There was an exception thrown trying to dispatch event '[com.atlassian.plugin.event.events.PluginModuleUnavailableEvent@182b084f, SingleParameterMethodListenerInvoker{method=public void com.atlassian.plugin.manager.DefaultPluginManager.onPluginModuleUnavailable(com.atlassian.plugin.event.events.PluginModuleUnavailableEvent), listener=com.atlassian.jira.plugin.JiraPluginManager@35787ffa}]' from the invoker 'java.lang.RuntimeException: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'com.atlassian.jira.plugin.devstatus.summary.indexing.DevSummaryIssueSearchExtractor': Unsatisfied dependency expressed through constructor argument with index 0 of type [com.atlassian.jira.plugin.devstatus.summary.cache.DevSummaryCache]: : Error creating bean with name 'applicationLinkService': FactoryBean threw exception on object creation; nested exception is org.springframework.osgi.service.ServiceUnavailableException: service matching filter=[(&(objectClass=com.atlassian.applinks.api.ApplicationLinkService)(objectClass=com.atlassian.applinks.api.ApplicationLinkService))] unavailable; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'applicationLinkService': FactoryBean threw exception on object creation; nested exception is org.springframework.osgi.service.ServiceUnavailableException: service matching filter=[(&(objectClass=com.atlassian.applinks.api.ApplicationLinkService)(objectClass=com.atlassian.applinks.api.ApplicationLinkService))] unavailable' 2015-03-12 05:48:29,383 JiraImportTaskExecutionThread-1 INFO anonymous 347x93x1 7xttoo 10.92.96.167 /secure/SetupImport.jspa [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml

This widget could not be displayed.

Hi Joanne, 

It looks like this log is showing a bad shutdown. Unfortunately it's tough to say what happened before this event. Can you post in your full atlassian-jira.log for us? 

I verified it and it seems to have imported with no problems as everything working as it was. Thanks.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

573 views 25 15
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you