Back Forward About the Purge/Archive wizards

In a production application, work item data volume can grow to a size where hundreds of megabytes of database storage is required. The Purge/Archive wizards enable you to use an agent to automatically delete old work item data from the respective tables and/or store them in ZIP archive files. Purging and archiving old work items and their related history and attachment records helps maintain system performance by reducing database processing demands.

Scope

Archiving work item data enables you to retrieve them if needed for audits or for backups. Note the following:

Overview

You use the Purge/Archive wizard to set up the agent activity in two phases:

Phase 1: Configure the activity — Define the dataset that will be purged/archived. The dataset comprises a work pool in your application, and a set of work types (classes), folders, and covers within the work pool. The dataset is also qualified by the age of resolved work items to be purged/archived. Each configuration is an instance in class Data-Admin-ArchiveSettings.

Phase 2: Schedule the activity — For each cycle you specify:

At the defined cycle start time, the purge/archive agent first populates an archive ZIP file with the work items and their data as defined in Step 1. The agent then deletes the table data. Although the work items are purge/archived, the work item ID is left unchanged, to allow restoration or archived wok items without affecting current work items.

About the ZIP file

The ZIP files created by the wizard uses the following naming convention:

<workpool name_dataset name_ file creation date_runn >

for example:

MyCo-Classgroup_AlphaPurge_20070409T22440_0.zip

Note A run value of 0 (zero) designates the first run.

The ZIP files are stored in the PRPC system temporary directory configured for your installation.

Prerequisites

Before you use the Purge/Archive Wizard, do the following:

Indexes created for work items are deleted but not archived. The indexes are recreated when the work items are recovered from the archive. For example, work party indexes (table pc_index_workparty) are purged but not archived. When the work item is recovered, the work party index is recreated.

Using the wizards

Two wizards comprise the Purge/Archive wizard:

Configuration wizard: Select > System > Tools > Purge/Archive Configure when you are:

Scheduling wizard: Select > System > Tools > Purge/Archive Schedule when you are:

Click the Help button (Help) on any form for information about that form.

Restoring archived work items

To retrieve archived work items in your archive system, select> Application > Import & Export > Import.

By default, a setting in prconfig.xml limits the size of an imported file to 25MB. To upload files that exceed this limit, you can either change the setting or use a file transfer tool such as FTP. For more information, see PDN article How to import large archive .zip files using the Import Rules/Data tool.

As an alternative to the prconfig.xml file, you can use Dynamic System Settings to configure your application.
See How to create or update a prconfig setting.

Testing the Purge/Archive wizard

Before using the wizard in a full-scale production system, it is strongly recommended that you test the wizard as follows:

  1. Schedule a near-term purge/archive cycle using a test set of resolved work items. Confirm that they and their related data are deleted from your application pc_work table and from the tables listed above in the preceding Prerequisites section. You can use Find by ID to verify that the items are not available.
  2. Use the Scheduling wizard and enter the agent information (work pool and name) you used for the test. This opens the user form. In the Interval Statistics section, open the entry for the date of the run. Verify that the number of work items and work-related records purged/archived are correct. Verify that the ZIP file has been created.
  3. Purge a cover work item that contains resolved work items. Verify that all the work items inside the cover were successfully deleted.
  4. Purge a folder work item that contains a cover. Verify that the cover was deleted.
  5. Purge a folder that contains a cover that, in turn, contains resolved and unresolved work items. Confirm that none of them are purged.
  6. Create a folder with a work item inside the folder. Check for an entry in the table pc_link_folder. Purge the folder and then verify that the entry in the link table is deleted.
  7. Upload and import the ZIP file into your archive system. Verify that all the data is recovered.

Security

By default, only operators who hold the PegaRULES:SysAdm4 role can use these wizard.

To make this available to others.

  1. Identify an access role associated with the operators who are to hold the privilege.
  2. Open the Rule-Access-Role-Obj rule for the role you want to grant access, using @baseclass as the second key part.
  3. On the Privileges tab, add the PurgeArchiveConfigure privilege to the list with the appropriate access level. Save the form.
Definitions archive tools
Related topics Working with the PegaRULES database — Tables for work items
Completing the Import Zip file option
Understanding the Pega-ImportExport agent

UpTools — System