Scripts used for the maintenance of the RPA database: purging, index and size maintenance. Available for MSSQL, Oracle and PostgreSQL.
Package contains procedures for RPA releases only. Certain procedures may not apply to your database configuration (example: Oracle LOB shrinking doe not work on securefile LOBs), but are provided for those configurations which support them. In case a procedure encounters an unsupported configuration an error message explaining this will be displayed.
Suggested for you are based on app category, product compatibility, popularity, rating and newness. Some apps may not show based on entitlements. Learn more about entitlements.
Added support for 2021.02 and changed execution auxiliary data delete method in order to better delete data from the execution bound inputs, execution bound outputs and executed flow graph tables.
Added support for 2020.11.
Added a trigger creation script for handling oid data on PostgreSQL
Changed MSSQL deep clean procedure to improve efficiency of delete.
Fixed on MSSQL a potential endless loop on delete due to batch population.
Added support for 2020.08
Reduced min batch size to 10,000 where previously was set for 1,000,000 in order to reduce resource contention on weaker databases.
Added 2020.02 compatibility, added purge remote debug procedure, fixed possible collision on purge of running exec configs.
Procedure supports both RPA 2019.07 and 2019.11.
Procedures utilize external tables to store identifiers for data that is supposed to be deleted. Before installing the procedure itself run the script to create the purge tables. The script is located in the same folder as the procedure.
Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox
