Exporting and deleting archived data
Archive data management operations
You can export data only in CSV format. The following operations are available:
- Export and Delete—Copies the archived data, which is the same age or older than the Age in Days value to a set of .csv files and then deletes the exported data from the archive form for all policies. This option is available for on-premises subscribers only.
- Export—Copies archived data, which is equal to or older than the Age in Days value to the .csv files, but leaves the data on the archive form. This option is available for on-premises subscribers only.
- Delete—Deletes archived data, which is equal to or older than the Age in Days value from the archive forms. This option is available for SaaS and on-premises subscribers.
- Export to SFTP and Delete—Exports files to a Secured File Transfer Protocol (SFTP) location and deletes the data from the archived form. This option is available for SaaS and on-premises subscribers.
Before using the Export SFTP option, make sure that the following parameters in the Centralized Configuration are set:
Best practices for exporting and deleting archived data
- Do not perform the export operation during peak hours or while doing upgrades. Although you can cancel an archiving run after it starts, you cannot cancel an export operation.
- Exporting and deleting archive data is an asynchronous operation. To trigger the operation, the AR System Archive Manager console creates an entry in the AR System Archived Data Management back end system form. The workflow defined on this form, hands off the job to an internal plug-in that runs in the background.
- In a server group environment, the export and delete operation runs on the server on which the operation was created. However, if the mid tier is connected to a load balancer, the job could be sent to any of the servers in the group that are behind the load balancer.
- If you need the export and delete operation to run on a specific server in the group, you must point the mid tier directly to that server before you start the operation.
To export archive data
- Log on to the Mid Tier.
- Open AR System Administration > AR System Archive Manager Console.
The following image shows the AR System Archive Manager Console: - From the Operation list, select one of the following options:
- Export and Delete
- Export
- Delete
- Export to SFTP and Delete
- In the Age in Days field in the System Archive Export section, enter the age of the archive.
- Click Export.
The Export function creates a directory under the following path and writes the exported files to that directory: <ARInstallationDirectory>/ARServer/Db
The Export Successfully message is displayed when the export job is successfully submitted to the Archived Data Management form. You can monitor the Status of the archive job by opening the Archive Data Management form.
Result
When the export is complete, the Result field displays the directory containing the exported archive having the <AGGAA5V0HGXU0ANJECBEAAAFI4HFYR> format. If the operation fails, the Result field displays an error message with information about why it failed. You can see detailed error logs in the arextension.log file located in the ARInstallationDirectory/ARServer/Db directory.
The following image shows the archived data on an SFTP location:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*