After an archived item is restored, when you search for that item and open it, the tabs on the form are not displayed correctly. This makes it appear as if the restored record is missing data . The data is not actually missing.
After searching the archived items in the 'Advanced search' no data met with these conditions. The problem is the option "Search in Sub-projects" if it this is selected no data is returned. The workaround is to uncheck this option in the reports.
In upgrade step: UpgradeDataTo1130000008, we need to ignore fields for the archive tables for system tables such as TS_CHANGES, TS_CHANGEACTIONS, and TS_CHANGETEXT. e.g.
With on demand you get the on-premise message when deleting a project. The message implies that there is an option that you can access the data via other reporting tools. This is not true in on-demand environment as archive is not available.