Jira System Restore is failing

Deleted user February 13, 2019

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

 

 

1 answer

1 accepted

0 votes
Answer accepted
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2019

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

Deleted user February 14, 2019

Thank you, Alex. 

You've saved me once again.

Jim

Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 14, 2019

@[deleted] You are most welcome!

arno
Contributor
November 11, 2024

Hi @Alexey Matveev 

   We encountered the same error when recovering the data, as shown below

er.png

I don't understand what you mean. What should we do to solve this problem? Meanwhile, our activeobjects.xml file is relatively large (20GB), is there a better way to edit this file

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events