Page Comparison

...

For further information, also see Archive Cleaner in 3.1.1 Workflow Types.

Resetting entry_id Sequence

For each new archived file, the agent will add an entry in the database with an incremental sequence number known as entry_id. This sequence number will NOT auto cycle after reaching its maximum value. The user is required to manually alter or reset the sequence in this scenario to prevent overflow.

You can use the following SQL statements for resetting the entry_id.

Oracle

ALTER SEQUENCE MZOWNER.SEQ_ARCHIVE_ENTRY_ID CYCLE;

PostgreSQL

ALTER SEQUENCE mzowner.archive_entries_entry_id_seq CYCLE;