Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The JS7 - Database will grow according to the number of workflows and jobs being executed. This includes an increase of data in the following areas:
    • Order History, Task History, Order Logs, Task Logs
      • The history includes JS7 - History includes one record for each execution of an order and a number of records corresponding to the tasks executed with a workflow.
      • In addition, any log output created from jobs is stored in a compressed format.For details see JS7 - History
    • Deployment History
      • Any operation to deploy an object, e.g. a workflow, is recorded, see JS7 - Deployment
    • Daily Plan History
      • For each day the JS7 - Daily Plan Service will create respective orders that are maintained in the database.
      • In addition order variables are recorded with the Daily Plan History.
    • Audit Log
      • Each operation to modify the status of an object is recorded, this includes
        • orders created and submitted by the Daily Plan Service and by the Daily Plan view,
        • ad hoc orders added by users or clients using the JS7 - REST Web Service API
        • deployments of workflows and related objects
        • operations that suggest intervention such as to cancel, to suspend and to resume orders.
      • The Audit Log is persisted with both the database and the respective log file, see JS7 - Log Files and Locations

...

  • Execution Frequency
    • The days for execution of the service can be specified. If no days are specified then the service will not run and purge of the database remains a task to be completed manually.
    • For each day specified the service will run within the begin and end of the period specified.
    • It is recommended to choose days and periods with relaxed scheduling activity as this will reduce the number of times the Cleanup Service is interrupted by such activity. However, there will be no interference if workflows are executed while the service is running.
  • Objects subject to Purge
    • Order History and Task History are purged in a common operation. 
    • Order logs and task logs are stored with the Order History and are purged when exceeding the specified retention period specified. A frequent use case is to purge logs after a shorter retention period and to retain the execution history for a longer period as logs consume more space in the database. Consider that it makes no sense to use a longer retention period for order logs and task logs than for the Order History as the logs would not be accessible by the GUI.
    • The history of Daily Plan submissions usually is relevant for a shorter period only. It is mostly used to detect if for certain days no orders have been submitted particularly when the Daily Plan is manually managed by a user and is not automated by use of the JS7 - Daily Plan Service.
    • For the Deployment History the number of deployments per object is specified, e.g. workflow, that should be retained is specified. If this number is exceeded then older deployment history entries will be purged.
    • The audit log configuration should be considered with care as it can be subject to compliance requirements.
  • For further information about configuration and logging see JS7 - Cleanup Service

...