Can not restore Jira from data xml backup

[Gerardo_E__Alvarenga]

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

[Alexey Matveev _cPrime_]

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

[Gerardo_E__Alvarenga]

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

<table name="AO_5FB9D7_AOHIP_CHAT_LINK">
<column name="ADDON_TOKEN_EXPIRY" primaryKey="false" autoIncrement="false" sqlType="93" precision="23" scale="10"/>
<column name="API_URL" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="CONNECT_DESCRIPTOR" primaryKey="false" autoIncrement="false" sqlType="2005" precision="2147483647"/>
<column name="GROUP_ID" primaryKey="false" autoIncrement="false" sqlType="4" precision="10"/>
<column name="GROUP_NAME" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="ID" primaryKey="true" autoIncrement="true" sqlType="4" precision="10"/>
<column name="OAUTH_ID" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="SECRET_KEY" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="SYSTEM_PASSWORD" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="SYSTEM_TOKEN_EXPIRY" primaryKey="false" autoIncrement="false" sqlType="93" precision="23" scale="10"/>
<column name="SYSTEM_USER" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="SYSTEM_USER_TOKEN" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="TOKEN" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
</table>
<table name="AO_5FB9D7_AOHIP_CHAT_USER">
<column name="HIP_CHAT_LINK_ID" primaryKey="false" autoIncrement="false" sqlType="4" precision="10"/>
<column name="HIP_CHAT_USER_ID" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="HIP_CHAT_USER_NAME" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="ID" primaryKey="true" autoIncrement="true" sqlType="4" precision="10"/>
<column name="REFRESH_CODE" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="USER_KEY" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="USER_SCOPES" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="USER_TOKEN" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
<column name="USER_TOKEN_EXPIRY" primaryKey="false" autoIncrement="false" sqlType="93" precision="23" scale="10"/>
<foreignKey fromTable="AO_5FB9D7_AOHIP_CHAT_USER" fromColumn="HIP_CHAT_LINK_ID" toTable="AO_5FB9D7_AOHIP_CHAT_LINK" toColumn="ID"/>
</table>

<data tableName="AO_5FB9D7_AOHIP_CHAT_LINK">
<column name="ADDON_TOKEN_EXPIRY"/>
<column name="API_URL"/>
<column name="CONNECT_DESCRIPTOR"/>
<column name="GROUP_ID"/>
<column name="GROUP_NAME"/>
<column name="ID"/>
<column name="OAUTH_ID"/>
<column name="SECRET_KEY"/>
<column name="SYSTEM_PASSWORD"/>
<column name="SYSTEM_TOKEN_EXPIRY"/>
<column name="SYSTEM_USER"/>
<column name="SYSTEM_USER_TOKEN"/>
<column name="TOKEN"/>
</data>
<data tableName="AO_5FB9D7_AOHIP_CHAT_USER">
<column name="HIP_CHAT_LINK_ID"/>
<column name="HIP_CHAT_USER_ID"/>
<column name="HIP_CHAT_USER_NAME"/>
<column name="ID"/>
<column name="REFRESH_CODE"/>
<column name="USER_KEY"/>
<column name="USER_SCOPES"/>
<column name="USER_TOKEN"/>
<column name="USER_TOKEN_EXPIRY"/>
</data>