Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-1817

Cleanup Service - The cleanup feature does not work for history logs if the settings order_history_age and order_history_logs_age have different values

    XMLWordPrintable

Details

    Description

      Current Situation

      • The JS7 Cleanup Service, see linked article, purges the database from older records. Users specify the retention periods for history records etc. with JOC Cockpit Settings.
      • The cleanup feature does not work for history logs (table HISTORY_LOGS) if the settings order_history_age and order_history_logs_age have different values,

      Desired Behavior

      • The Cleanup Service should remove data as indicated by JOC Cockpit Settings.

      Test Instructions

      • JOC Cockpit -> Settings - cleanup section
      • Note: The setting values ​​are for example only. Use your own values ​​based on the history entries available in the database.
      • Perform the test with the same value for both settings, e.g. 90d
      • Perform tests with the different values:
        • order_history_age (e.g. 89d) greater than order_history_logs_age (e.g. 88d)
        • order_history_age (e.g. 86d) less than order_history_logs_age (e.g. 87d)
      • Expected result - in any case, the service-cleanup.log should contain lines indicating that the HISTORY_LOGS table cleanup was performed based on the appropriate settings

      Attachments

        Issue Links

          Activity

            People

              re Robert Ehrlich
              re Robert Ehrlich
              Divyani Rathore Divyani Rathore
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: