Maintaining Robot Manager History Tables for Robot Manager V8.3.1 and earlier
Maintaining Robot Manager History Tables for Robot Manager V8.3.1 and earlier
Summary
Robot Manager v8.3.1 and earlier you need to manually maintain the robot operator work history in an environment. If the maintenance is not performed on an environment, overtime it will lead to significant slowness while interacting with Robot Manager Dashboard and increase in completion time of robotic API service call like the registration, and heartbeat.
In v8.4 and later of Robot Manager has an out-of-the-box scheduled job that will perform the maintenance periodically in the background. Therefore, this process can be ignored for those versions.
NOTE: This is only true for an environment using Robot Runtime in RPA mode. The history tables don’t grow exponentially for an RDA Robot Runtime environment that would be a cause of concern.
Classname (pxobjclass) | Table | Purpose |
History-Data-Robot-Automations | pr_data_robot_automation_audit | Automation work history |
History-Data-Robot-Events | pr_data_robot_event_audit | Robot audit history |
History-Data-Admin-Operator-ID | pr_history_data | Robot and RPA Service operator heartbeat calls history |
Run the following command to check the count of rows for each of the table:
SELECT COUNT(*) FROM $TableName
If an environment uses Pega Diagnostics Cloud (PDC) the table information can be retrieved from the Database tab.
Cleaning up the Robot Manager history tables
You can maintain the Robot Manager history through the following means:
- Run the out-of-the-box activities periodically through a background agent/job scheduler.
- Run a backend database job that periodically purges/archives the table based on their use case.
Out-of-the-box activities that run through background agent/job scheduler
pxArchiveRobotAutomations (ClassName: History-Data-Robot-Automations)
Moves the automation history of a robot from pr_data_robot_automation_audit to pr_data_robot_automation_audit_archive table
pxArchiveRobotEvents (ClassName: History-Data-Robot-Events)
Moves the robot audit rows from pr_data_robot_event_audit to pr_data_robot_event_audit_archive table
pxPurgeRobotOperatorHistory (ClassName: History-Data-Admin-Operator-ID)
Deletes the robot operator history from the pr_history_data table
Archived data are moved to a different table, so the information is not actively fetched by Robot Manager interaction.
Information on creating the job scheduler task and background agent is available on Pega Community.
Backend Database Job
Schedule a backend database job with assistance from the DBA that identifies the rows to be purged based on the business requirement.