Description

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 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
OO Containerized Database Management 5.7
512.8 KB
  |  
May 26, 2022
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.08 · 2019.11
Version 2020.02 · 2020.05 · 2020.08 · 2020.11
Version 2021.05 · 2021.11
Version 2022.05
Release notes

Added support for 2022.05 release

Languages
English
Files
OO Containerized Database Management 5.6
437.1 KB
  |  
Oct 27, 2021
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.08 · 2019.11
Version 2020.02 · 2020.05 · 2020.08 · 2020.11
Version 2021.05 · 2021.11
Release notes

Added compatibility for 2021.11 release.

Languages
English
Files
OO Containerized Database Management 5.5
436.6 KB
  |  
May 10, 2021
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.08 · 2019.11
Version 2020.02 · 2020.05 · 2020.08 · 2020.11
Version 2021.05
Release notes

Added support for 2021.05 and reworked logic for deleting bound inputs, bound outputs, executed flow graphs.

Languages
English
Files
OO Containerized Database Management 5.4
318.4 KB
  |  
Dec 7, 2020
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.07 · 2019.08 · 2019.11
Version 2020.02 · 2020.05 · 2020.08 · 2020.11
Release notes

Added 2020.11 support. Added scripts for creating oid deletion triggers.

Languages
English
Files
OO Containerized Database Management 5.3
316.8 KB
  |  
Oct 13, 2020
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.07 · 2019.08 · 2019.11
Version 2020.02 · 2020.05 · 2020.08
Release notes

Changed MSSQL deep clean procedure for imp[roved speed of deletion.

Fixed on MSSQL a potential endless loop caused by batch population strategy.

Languages
English
Files
OO Containerized Database Management 5.2
315.8 KB
  |  
Sep 14, 2020
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.07 · 2019.08 · 2019.11
Version 2020.02 · 2020.05 · 2020.08
Release notes

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.

Languages
English
Files
OO Containerized Database Management 5.1
315.6 KB
  |  
May 29, 2020
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.08 · 2019.11
Version 2020.02 · 2020.05
Release notes

Added support for 2020.05

Languages
English
Files
OO Containerized Database Management 5.0
315.7 KB
  |  
Mar 19, 2020
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.07 · 2019.08 · 2019.11
Release notes

Added compatibility for 2020.02, fixed issues with potential collision on purge of running exec configs, added procedure for purge of remote debug data

Languages
English
Files
OO Containerized Database Management 4.9
207.4 KB
  |  
Nov 19, 2019
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.08 · 2019.11
Release notes

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.

Languages
English
Files
OO Containerized Database Maintenance 4.8
120.2 KB
  |  
Sep 4, 2019
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Version 2019.02 · 2019.05 · 2019.08
Release notes

Added support for 2019.05 and 2019.08

Removed retention period from purge plans.

Added OO_executed flow graphs to purge history

Languages
English
Files
OO Containerized Database Maintenance 4.6
406.9 KB
  |  
Jan 29, 2019
More info Less info
Product compatibility
Version 2018.05 · 2018.08 · 2018.11
Release notes

Release of the maintenance pack for containerized version compatibility.


Internal containerized postgresql database not currently supported.

Languages
English

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 OpenText 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-2024-3-2-6097 | Wed Mar 27 04:29:56 PDT 2024