BMC Helix Digital Workplace Catalog: How to clean the Process History tables.

Product

BMC Helix Digital Workplace Advanced

Component

MyIT Service Broker

Applies to

19.x, 20.x, 21.x

Problem

Problem: How to clean Process Execution data from BMC Helix Digital Workplace

Cause

Solution

Solution:
There are multiple options and depending upon the version, you can choose the appropriate option.

In 21.x, you can enable the archive policy and adjust the schedule according to your needs.

Note: Please ensure to delete the data from archive as well after aging out days.

2.   If you are on the 20.02.03 version, on-Prem, you can enable this via script
To Enable/Disable a feature
[root@MyITSBServer digitalworkplace]# cd sb/rxscripts/
[root@MyITSBServer rxscripts]# source ./bin/setenv.sh
[root@MyITSBServer rxscripts]# ./bin/login.sh dwpadmin xxxxxxx
  Successfully logged in as dwpadmin.

  [root@ MyITSBServer rxscripts]# ./bin/enable_process_clean_feature.sh
Feature Enabled

Process data cleanup –
from-date - the date from which the data is considered for cleanup.
login as a tenant admin

For example -
./bin/login.sh Hannah_admin@bmc.com xxxxxx
./bin/update_settings.sh Process-Data-Cleanup-From 10-10-2020

You can monitor the startup log for more information on cleanup, arstartup_trace-2020-10-07-17-45-04.log

Wed Oct 07 17:36:22.352 2020 <THREADID: 42> <OPID: null> <USER: ARSERVER> <IMPERSONATEUSER: null> <TENANTID: 0> <CATEGORY: SERVER> <USER-AGENT: Unidentified Client> <MSG: ACT Table cleanup interval set to 60 minutes>

Wed Oct 07 17:36:22.352 2020 <THREADID: 42> <OPID: null> <USER: ARSERVER> <IMPERSONATEUSER: null> <TENANTID: 0> <CATEGORY: SERVER> <USER-AGENT: Unidentified Client> <MSG: Process Context Archive interval set to 180 minutes>

Wed Oct 07 17:51:30.143 2020 <THREADID: 609> <OPID: null> <USER: AR_ARCHIVER> <IMPERSONATEUSER: null> <TENANTID: TNGADG1AAP0ICAPWLS9UPVOHWH5HOG> <CATEGORY: SERVER> <USER-AGENT: null> <MSG: Found zero Process Instances to clean ACT tables>

3. If you are on SaaS running 20.02, 20.08 versions, You can request the support team to enable this feature

4. If you want to get delete the data from DB instead of enabling the feature regularly to not add overheads to the application, you can execute these SQLs.

Knowledge Article