Description

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 apps

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.

Releases

Release
Size
Date
RPA Database Maintenance 3.3
235.5 KB
  |  
Mar 18, 2021
More info Less info
Product compatibility
Version 2019.11.0
Version 2020.02.0 · 2020.08 · 2020.11
Version 2021.02
Release notes

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.

Languages
English
Files
RPA Database Maintenance 3.2
140.8 KB
  |  
Dec 7, 2020
More info Less info
Product compatibility
Version 2019.11.0
Version 2020.02.0 · 2020.08 · 2020.11
Release notes

Added support for 2020.11.

Added a trigger creation script for handling oid data on PostgreSQL

Languages
English
Files
RPA Database Maintenance 3.1
139.2 KB
  |  
Oct 13, 2020
More info Less info
Product compatibility
Version 2020.11 · 2020.02.0 · 2020.08
Version 2019.11.0
Release notes

Changed MSSQL deep clean procedure to improve efficiency of delete.

Fixed on MSSQL a potential endless loop on delete due to batch population.

Languages
English
Files
RPA Database Maintenance 3.0
138.7 KB
  |  
Sep 14, 2020
More info Less info
Product compatibility
Version 2020.11 · 2020.02.0 · 2020.08
Version 2019.11.0
Release notes

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.

Languages
English
Files
RPA Database Maintenance 2.0
137.9 KB
  |  
Mar 19, 2020
More info Less info
Product compatibility
Version 2020.11 · 2020.08 · 2020.02.0
Version 2019.11.0
Release notes

Added 2020.02 compatibility, added purge remote debug procedure, fixed possible collision on purge of running exec configs.

Languages
English
Files
RPA Database Maintenance 1.0
71.2 KB
  |  
Nov 19, 2019
More info Less info
Product compatibility
Version 2019.11.0
Release notes

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.

Languages
English
Files

Unsubscribe from notifications

You are receiving release updates for this item because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service
Since you are downloading an app from the Micro Focus Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.


Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2022-1-1-4548 | Wed Jan 19 06:11:08 PST 2022