We're getting a Restore system error. Does anyone know what is going on?

[Deleted user]

I was doing a system restore from a zip file created 1 week ago and am ready to just download and install a whole new JIRA onto my PC to try to solve this. 

Here is the error:

Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE PUBLIC.AO_60DB71_QUICKFILTER_COPY_525_84 DROP CONSTRAINT fk_ao_60db71_quickfilter_copy_525_84_rapid_view_id'

Here is the last 50 or so lines from the atlassian-jira.log

2018-09-26 16:51:03,286 JiraImportTaskExecutionThread-1 DEBUG malgerij 1011x1861x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] startCleaning
2018-09-26 16:51:04,871 JiraImportTaskExecutionThread-1 DEBUG malgerij 1011x1861x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] stopCleaning
2018-09-26 16:51:04,871 JiraImportTaskExecutionThread-1 ERROR malgerij 1011x1861x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE PUBLIC.AO_60DB71_QUICKFILTER_COPY_525_84 DROP CONSTRAINT fk_ao_60db71_quickfilter_copy_525_84_rapid_view_id'
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE PUBLIC.AO_60DB71_QUICKFILTER_COPY_525_84 DROP CONSTRAINT fk_ao_60db71_quickfilter_copy_525_84_rapid_view_id'
at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)
at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:46)
at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:67)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:992)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:727)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:324)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:60)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:157)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:133)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.h2.jdbc.JdbcSQLException: Constraint "FK_AO_60DB71_QUICKFILTER_COPY_525_84_RAPID_VIEW_ID" not found; SQL statement:
ALTER TABLE PUBLIC.AO_60DB71_QUICKFILTER_COPY_525_84 DROP CONSTRAINT fk_ao_60db71_quickfilter_copy_525_84_rapid_view_id [90057-185]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.ddl.AlterTableDropConstraint.update(AlterTableDropConstraint.java:41)
at org.h2.command.Command.executeUpdate(Command.java:254)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:130)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:115)
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234)
at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234)
at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:34)
... 16 more
2018-09-26 16:51:04,874 JiraImportTaskExecutionThread-1 WARN malgerij 1011x1861x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2018-09-26 16:51:04,875 JiraImportTaskExecutionThread-1 INFO malgerij 1011x1861x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 100% complete...
2018-09-26 16:51:04,875 JiraImportTaskExecutionThread-1 INFO malgerij 1011x1861x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
2018-09-26 16:51:07,327 http-nio-8080-exec-14 WARN malgerij 1011x1862x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore!finish.jspa [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'java.lang.reflect.UndeclaredThrowableException - null'.
2018-09-26 16:51:07,328 http-nio-8080-exec-14 WARN malgerij 1011x1862x1 s56hc2 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore!finish.jspa [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'java.lang.reflect.UndeclaredThrowableException - null'.

[Alexey Matveev · Accepted solution]

Hello,

Open your Jira database, to which you are trying to install a backup,  and have a look if you have a constraint  called fk_ao_60db71_quickfilter_copy_525_84_rapid_view_id for the AO_60DB71_QUICKFILTER_COPY_525_84f table. If you do not have it then create a new foreign key constraint with the fk_ao_60db71_quickfilter_copy_525_84_rapid_view_id name. It must reference AO_60DB71_<something with rapid view>. And try to import data again.

[Deleted user]

Thanks, Alexey.  What you're talking about is totally new territory for me - so I might get back to you on this.