ORA-00942 error with unknown plugin during backup restore

Still need help?

The Atlassian Community is here for you.

Ask the community

This article only applies to the Atlassian server platform. Learn more about the differences between cloud and server.

Problem

When attempting a restore of an XML backup to a JIRA instance with an Oracle database, it fails to complete with ORA-00942 table or view does not exist

The following appears in the atlassian-jira.log:

2015-09-17 13:19:40,370 JiraImportTaskExecutionThread-1 ERROR anon 715x77x1 aa 1.1.1.1 /secure/SetupImport.jspa [jira.bc.dataimport.DefaultDataImportService] 
Error during ActiveObjects restore
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin> (table ):
Caused by: java.sql.BatchUpdateException: ORA-00942: table or view does not exist

Diagnosis

There are third party add-ons that were already installed prior to restoring the XML backup.

Cause

A third party add-on is interfering with the upgrade process. It is currently unknown which add-on is causing this, as the error message does not show it:

There was an error during import/export with <unknown plugin> (table ):

Resolution

Remove all third party add-ons before restoring the XML backup.

  1. Stop JIRA.
  2. Make a backup copy of your add-ons in $JIRA_HOME_Directory/plugins/installed-plugins/
  3. Delete the contents of the installed-plugins folder.
  4. Restart JIRA and retry the XML restore.
tip/resting Created with Sketch.

If the previous failed attempt of the XML restore causes JIRA to be inaccessible (due to data being overwritten or incomplete restore) then you will need to reset the JIRA database to a blank database before retrying the XML restore.

Last modified on Nov 14, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.