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
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:
Thank you, Alex.
You've saved me once again.
Jim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@[deleted] You are most welcome!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We encountered the same error when recovering the data, as shown below
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
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.