Maintaining Archives

Maintaining Archives

For workflows that use the Archiving agent, the Archive Cleaner task removes outdated archives that expire according to the purge criteria in the Archive profile. Archive Cleaner removes both the reference from the Platform database and the corresponding files from the archive directory.

Accessing Archive Cleaner

To access Archive Cleaner in Desktop:

  1. Click the Tools button in the upper-left area of the window.

  2. Open Execution Manager.

You can configure the scheduling criteria for Archive Cleaner only in the Archive Cleaner workflow group configuration. The schedule that you define controls when Archive Cleaner runs and removes outdated files.

For more information, see Workflow Types.

Resetting entry_id Sequence

For each new archived file, the Archiving agent adds an entry in the database with an incremental sequence number, known as entry_id. This sequence number does not auto-cycle after it reaches its maximum value. You must manually alter or reset the sequence in this scenario to prevent overflow.

You can use the following SQL statements to reset the entry_id sequence.

Note!

When you reset entry_id, you must run Archive Cleaner so that newer archive entries do not clash with older entries.

Oracle

ALTER SEQUENCE MZOWNER.SEQ_ARCHIVE_ENTRY_ID CYCLE;

PostgreSQL

ALTER SEQUENCE mzowner.archive_entries_entry_id_seq CYCLE;