...
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.
...
| Note | ||
|---|---|---|
| ||
When resetting entry_id, you are required to execute the Archive Cleaner so that newer archive entries will not clash with the older entries. |
Oracle
| Code Block | ||
|---|---|---|
| ||
ALTER SEQUENCE MZOWNER.SEQ_ARCHIVE_ENTRY_ID CYCLE; |
PostgreSQL
| Code Block | ||
|---|---|---|
| ||
ALTER SEQUENCE mzowner.archive_entries_entry_id_seq CYCLE; |
...