目的

You might have mistakenly deleted an Insight object type when you just wanted to delete one Insight object, it happens.

However, it's not possible to restore a deleted Insight object or an object type or redo the deletion. We have a Suggestion ticket JSDSERVER-8650 - Introduce dedicated backup / restore functionality for Insight open for future implementation.

This KB is to outline a few possible ways to retrieve the deleted data.

ソリューション

• Restore Jira data from XML or database backup. This ensures that the deleted Insight data is completely recovered.
  •  This completely overwrites Jira application data and hence, any update made after the backup is made will be lost.
• If you have another Jira instance where the deleted data can be extracted, you could import it to the current instance via CSV import or object schema import.
  
  •  Imports create objects from scratch, new object keys will be created and object history will be overwritten. This also means that if a deleted object was connected to a Jira issue, the "restored" object will not be automatically connected as the link between objects and Jira issues will not be imported.
  • You should also note that any other schema or object type related configurations like import configurations, automations, roles etc will not be imported via object schema import.
• Restore only Insight-related database tables from your database backup that contains the Insight data to be recovered, using database native function to copy or migrate the data. All Insight-related database tables have the prefix of AO_8542F1.

  • We do not provide support to restore the data this way, as different database type with different version may have different ways to copy data from one database to another. We recommend engaging your DBA to determine the best way to copy between databases. 

    データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。