A set of scripts for maintanance of the Operations Orchestration database. The scripts are compatible with the containerized releases of the Operations Orchestration product.
The PostgreSQL scripts are not meant to be used with the HCM internal PostgreSQL database.
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 2022.05 release
Added compatibility for 2021.11 release.
Added support for 2021.05 and reworked logic for deleting bound inputs, bound outputs, executed flow graphs.
Added 2020.11 support. Added scripts for creating oid deletion triggers.
Changed MSSQL deep clean procedure for imp[roved speed of deletion.
Fixed on MSSQL a potential endless loop caused by batch population strategy.
Added compatibility 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 compatibility for 2020.02, fixed issues with potential collision on purge of running exec configs, added procedure for purge of remote debug data
Added support for 2019.11.
Created new procedures for collecting and deleting historical data that utilize actual tables instead of in memory structures for faster and more reliable deletion.
Created a standalone procedure for deep clean in order to be able to run only the deep clean procedure instead of both regular purge and deep clean.
Added hard stops and error codes for both timeout and database error in order to avoid padded runtime.
Purge procedures now support the option to continue a timed out purge.
Before installing the new procedures make sure to run the included script for creating the supporting tables.
Created sample invocation scripts for postgresql procedures.
Added support for 2019.05 and 2019.08
Removed retention period from purge plans.
Added OO_executed flow graphs to purge history
Release of the maintenance pack for containerized version compatibility.
Internal containerized postgresql database not currently supported.
Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox