I have a question about restoring the archived records.

[RajanMurkute]

I have a question about restoring the archived records.

I have two tables 'X' (active table) and 'ar_X' (archive table). Unwanted records are periodically archived and are removed from the active table. When I restore a record from 'ar_X' (archive table), the record is listed in the list view of active table 'X'. However when I open the record, I notice that all Related Lists and Tabs on the form are lost. This started happening ever since we upgraded our instance from Geneva to Istanbul.    

Is anyone using Istanbul release, aware of this issue? Any suggestions to fix this?

[Patrick Fedigan]

Hello Rajan,

Here is link that might be of use. Archiving Data - ServiceNow Wiki

I am currently looking into replicating the issue in my own instance.

[RajanMurkute]

Patrick, thanks for the response.

I have gone over the article 'Archiving Data - ServiceNow Wiki'. My problem is with restoring records. The UI Action ' Restore record' runs successfully and displays message 'Record successfully restored'.

But when the restored record is opened, the form does not have 'Related Links', nor attachments, nor related lists and tab pages. Things worked well when we were on Geneva release. We recently upgraded to Istanbul release (we skipped Helsinki) and the problem occurred.

[Sabrina10]

You have to restore all the related records manually.   For example, if you were restoring an REQ record, you have to go find the RITMs that were associated with it and restore those manually.     Then you would need to find the Catalog Tasks that were associated with the RITM records and restore those too.   Repeat with any other related lists, such as approvals, metrics, time worked, and variables.   Of course, the availability of the related records depends on if you set them up to also archive, clear the reference, or be deleted.

As for attachments, check the sys_attachment table for the records.     The table field may still be pointing to ar_x instead of x.