AppXtender Restore Deleted Document

Recover Deleted Document in AppXtender

If a document is deleted, it can be retrieved by restoring the deleted records from AE_DT<appid> and AE_DL<appid> table along with the bin files associated with the AE_DL<appid> records.
Note:  The document can be restored ONLY if you have a back up of the database schema which contains the deleted records and the file system backup with the deleted bin file(s).     If you do not have this information, rescanning or reimporting then reindexing would be needed to get the deleted document back into the system.   



Here are the steps to perform to find the information for the deleted document:

1. Run the following query and note down the table names from dtname and dlname columns

select appid, appname, dtname, dlname from ae_apps order by appid;

2. Query the table AE_DT<appid> (dtname from step 1) and find the record for the deleted document. You'll need some index information from the record like customer id or whatever value is applicable for your application to find this row.

3. Using the value of docid column from the query output from Step 2, find all records for that docid in the table AE_DL<appid> (dlname from  step 1)

4. The objectid value for the records retrieved in Step 3 will be names of .bin files which need to be restored from the backup of the file system of the image storage location


Once you have all of this information, you have two options to get these back in the system:
A. Take all the .bin files you found and import them into the system and reindex them, which will create new  AE_DT<appid> and AE_DL<appid> records as well as new .bin files.
B. Restore the rows in  AE_DT<appid> and AE_DL<appid> in the live database as well as the .bin files to the live image storage location.  With this method, we recommend double checking the ensure the docid and objectid values do not exist in the live tables before restoration and the bin files do not exist in the live image storage locations (or if they do, that they match the files you have retrieved from backup in which case they can remain there and do not need to be overwritten). If any of these database values are present, please use method A so a new record is created.

If there are any questions, feel free to reach out to us at support@revolutiondatasystems.com so we can help you with this process.