Jira System Restore is failing

unknown

I was trying to do a system restore to another JIRA Server 7.10.0 instance on another PC. when I got the following error:

Error

There was a problem restoring ActiveObjects data for the <unknown plugin> plugin.

Caught exception with following message: There is already an object named ‘fk_ao_e8b6cc_pr_participant_pull_request_id’ in the database. Please check the log for details.

Here’s part of the log file: 

2019-02-13 14:27:03,577 JiraImportTaskExecutionThread-1 ERROR malgerij 866x220x1 gfjyfn 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE jiraschema.AO_E8B6CC_PR_PARTICIPANT ADD CONSTRAINT fk_ao_e8b6cc_pr_participant_pull_request_id FOREIGN KEY (PULL_REQUEST_ID) REFERENCES jiraschema.AO_E8B6CC_PULL_REQUEST_COPY_42562_44(ID)'

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'fk_ao_e8b6cc_pr_participant_pull_request_id' in the database.

This means nothing to as I am not really knowledgeable about databases.

Does anyone know how to resolve this or know of any documentation I could read about the problem?

Thank You,

Jim

 

 

Alexey Matveev

Hello,

You can extract the backup zip file. Open the activeobjects.xml file find the foreign key and delete the table declaration and data for this table in this file. then zip files back and restore it.

You can read more about it in my article:

https://community.atlassian.com/t5/Jira-articles/How-to-clean-irrelative-ActiveObjects-data-in-Jira-backup/ba-p/875608