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
Im my case, I was using mysql 8.
I have changed to mysql 5.7 and issue were gone.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.