Can not restore Jira from data xml backup

Question

When I tried to resotre Jira software from a xml backup file, I got this 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_5FB9D7_AOHIP_CHAT_USER DROP CONSTRAINT fk_ao_5fb9d7_aohip_chat_user_hip_chat_link_id'

Anyone has same issue? I have no idea what is going on.

Thanks

Gerardo_E__Alvarenga · Answer

I have deleted all the lines for the AO_5FB9D7 but it still does not work.

Alexey Matveev · Answer

Hello,

Unarchive your backup and remove all lines for the AO_5FB9D7 entities in the activeobjects.xml files. Then archive the files again and restore the archive.

You can read more in this article:

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