Highlighted
vgodoy Regular Contributor.
Regular Contributor.
291 views

oopurgehistory error

Version HPOO 10.70 and database postgres 9.2

Some weeks ago we have a problem with some flows and as a result the table oo_step_log_bindings increase the space to 90GB!

We got errors executing the Microfocus recommendations to purge (using the purging flow and also using the postgres purge function we got a malfunction because when it arrive to the record related to flowid that I need to purge, it abends! It seems as it can't manage type bigint -probably due to the stuck-loop error experimented in the flows-).

error_bigint_storedProc.PNG

To sum up: I would like to know if its possible to manually delete some registers from the oo_step_log_bindings table using SQL commands.

Thank you.

0 Likes
1 Reply
Outstanding Contributor.. JarodMB Outstanding Contributor..
Outstanding Contributor..

Re: oopurgehistory error

Id suggest opening a support case so they may review and provide guidance - make sure you're on the latest purge script - the id field was updated within the last few releases 

Yes - you can delete stuff yourself but that could create orphaned data. 

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.