1. Log maintenance settings

    Article: AN0002132Updated: 28.01.2021

    There are rules for deletion of old data from logs and archive tables defined on this page.

    Toolbar

    Icon Description
    Saving changes

    Section: System logs

    • Error log - activation and set up of number of days after which records from log ErrorLog shall be deleted.
    • User access in OG system - activation and set up of number of days after which records from log UserAccessLog shall be deleted.
    • Job start - activation and set up of number of days after which records from log JobStartLogs shall be deleted.
    • Sent emails - activation and set up of number of days after which records from log Emails shall be deleted.
    • Workflow start - activation and set up of number of days after which records from log WFSeqRuns shall be deleted.
    • Export start - activation and set up of number of days after which records from log ExportRuns shall be deleted.
    • Import start - activation and set up of number of days after which records from log ImportRuns shall be deleted.
    • Log maintenance exexution - activation and set up of number of days after which records from log DeleteOldDataLog shall be deleted.
    • Report execution -  activation and set up of number of days after which records from log ReportLog shall be deleted.
    • Execution of automated time based operations -  activation and set up of number of days after which records from log AutomaticTimeOperationRuns shall be deleted.
    • Global search - activation and set up of number of days after which records from log PersonSearch shall be deleted.
    • Scripts for execution - activation and set up of number of days after which records from log ScriptCallLogs shall be deleted.

    Some records may stay in the database tables even after the time set for log retention elapses. This is due to another records that are referring to these records that should be deleted. This situation happens mainly when the particular types of logs have different retention periods set. The records will be deleted once the referring records are deleted. 

    Section: Archive tables in model

    • Model - after selecting model classes with set up archiving are displayed. For these classes deletion of archive records older than a set up number of days can be activated.

    Row count in DB - It indicates number of rows in the database table. If there are more tables impacted, their row counts are separated by comma. This can give you an idea about log maintenance of which tables will have the highest impact on the database size.

×