Introduction
Completed Processes lists all finished processes and lets one check the historical data of each of the process instances as well.
Figure 1 shows the listing of all completed process instances. One may click into a particular process instance to view its information. (See Completed Process Instance)
Auto Archive
This is a new feature in Joget DX 8
Auto Archive automatically archives the completed processes to achieve better operational performance.
The purpose of the "Archive Process On Completion" feature is for faster performance when Joget works with the SHK process tables for active processes, by keeping the main SHK tables "small". Process archiving on completed processes "moves" the process records to the following DB tables: wf_history_activity, wf_history_process, wf_process_link_history. The archived processes are still accessible in the "Admin Bar > Monitor screen" or via database queries on the above process history tables.
Latest updates/changes (since 8.0.10):
- Joget uses an internal setting to keep track of the archiving status.
- The "Archived Processes" page will display the archive progress and have a new button to pause and resume the process migration.
- Will run the migration thread with a batch of 10 processes.
- When the migration status last run is longer than 15 minutes with no update, Joget will pause it and allow the user to resume at a later time.
Enable Auto Archive
There are 2 ways to enable Auto archive or Archive Process on completion
1. Click on the button as shown in Figure 2 to enable Auto Archive. Alternatively, one may refer to Figure 3 and select Archive Process On Completion under Process Completion Data Handling tab.
Figure 2 shows the button to enable Auto Archive.
The "Enable" button in "Monitor > Completed Processes" screen migrates (move) all existing completed process records to the history tables. We would recommend you perform the "Enable" after office hours as this will cause your Joget database to be very busy depending on how many completed process records you have in your system.
2. Select Archive Process On Completion under Process Completion Data Handling tab.
Navigate to Administrator Bar > Settings > General Settings > Process Completion Data Handling > Archive Process on Completion
When you set the General Settings "Archive Process On Completion" property, it will only archive all future new completed process records (applies to 8.0.6 and older builds only). The old or existing completed process records will remain unchanged. Process archiving on completed processes "moves" the process records to the following DB tables: wf_history_activity, wf_history_process, wf_process_link_history.
Enabling the 'Archive Process On Completion' option will initiate the data migration process to transfer completed process data to the historical tables immediately after saving. It is advisable to schedule this operation during non-peak hours for optimal performance.
Figure 3 shows the Settings.
- Always BACKUP your Joget database and Joget folders before performing the above, so that you can restore the data if needed.
- TEST on a development server for the General Settings "Archive Process On Completion" property change before doing the same on the production server to ensure your apps are working well.