Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error when importing Jira Backup

Craig Thacker September 3, 2019

Currently, I am trying to restore a backup of our old Jira 7.12.3 by moving it to  local VM, when I import the .zip/XML file, I get this error:

 

Error importing data: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM component (Table 'jiradb.component' doesn't exist))

 The original Jira application was hosted on an Ubuntu 18.04 VM and I am trying to move this to a CentOS 7 VM, both running MySQL.

I have exported the XML from our archived machine just the other day using a system administrator account, and I am unfamiliar with the original setup of our Jira server as it was my predecessor who completed it.

 

I originally tried importing with the most recent version of Jira and assumed the error (same as above) was because of a mis-matching version, so decided I'd install again using the same version.

 

Any tips on how I can restore the backup?

 

UPDATE:

 

I have also attempted the import on a Windows Server machine (also running MySQL) and got the same error:

 

Error importing data: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM component (Table 'jiradb.component' doesn't exist))

 

So I find it likely its a problem with my export but I'm unsure

1 answer

0 votes
juliangcorrea February 14, 2021

Same here. Waiting for solution.

juliangcorrea February 14, 2021

Im my case, I was using mysql 8. 
I have changed to mysql 5.7 and issue were gone.

Suggest an answer

Log in or Sign up to answer