Error when trying to import activeobjects.xml in JIRA 5.1.4

[Cesar Covarrubias]

We recently upgraded JIRA to version 5.1.4 from 5.0.2. When trying to restore our Greenhopper rapid boards by importing "activeobjects.xml", I get the following error:

Error importing data: org.xml.sax.SAXException: The XML document does not contain the <entity-engine-xml> root element or it was closed too early.

And the log output:

9-17 11:17:38,445 JiraImportTaskExecutionThread-1 INFO ccovarrubias 677x2182x1 j11xwe 10.0.0.116,127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Running JIRA Data Import...
2012-09-17 11:17:38,447 JiraImportTaskExecutionThread-1 INFO ccovarrubias 677x2182x1 j11xwe 10.0.0.116,127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Importing XML data...
2012-09-17 11:17:38,447 JiraImportTaskExecutionThread-1 INFO ccovarrubias 677x2182x1 j11xwe 10.0.0.116,127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Start parsing XML with SAX Parser.
2012-09-17 11:17:38,448 JiraImportTaskExecutionThread-1 ERROR ccovarrubias 677x2182x1 j11xwe 10.0.0.116,127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: org.xml.sax.SAXException: The XML document does not contain the <entity-engine-xml> root element or it was closed too early.
org.xml.sax.SAXException: The XML document does not contain the <entity-engine-xml> root element or it was closed too early.
	at com.atlassian.jira.action.admin.OfbizImportHandler.startElement(OfbizImportHandler.java:234)
	at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
	at org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentScannerImpl$ContentDispatcher.scanRootElementHook(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
	at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.parseXmlAndValidateBackupData(DefaultDataImportService.java:288)
	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:217)
	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65)
	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
	at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
	at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:679)

Any ideas?

[Arthur Gonçalves · Accepted solution]

Hello Cesar,

This problem happens because the XML parser doesn't recognizes the single file activeobjects.xml on the restore process.

Then, if you need to restore your GH boards, I'd recommend to you export your current JIRA data, replace the activeobjects.xml on the backup generated, and re-import again. :)

Cheers!

[Cesar Covarrubias]

When I imported my data into JIRA, both the entities.xml and activeobjects.xml file where in the jirahome/import directory. Shouldn't it have read the activeobjects.xml file on that initial import? how would this be any different?

[Arthur Gonçalves]

To restore both files you'll need to generate a .zip file and then use it to restore the database backup. They wouldn't restore upon only being placed on the same folder.

Cheers!

[TWLX]

1. Compress the activeobjects.xml and the entities.xml files only.
2. Import that compressed file.