HP Operations Orchestration Purge Execution Summary running non stop 10.22

Would require your help & support here in regards to our Purge Execution Summary flows in our environment used to delete old executions.

In recent months, we noticed in QA - Purge execution flows are in Long Running and we end-up cancelling our flows to avoid issues since it runs for a very long time and its not resolving. How can we fix this issue. 

Herewith, we also noticed content locks are kept in the table such as OO_RUNTIME_VALUE_STORE_KEY, OO_TRIGGER, OO_EXECUTION_ENTRY and its trying to write an entry for something that already exists due to which its failing.

1 Reply
Micro Focus Expert
Micro Focus Expert

Re: HP Operations Orchestration Purge Execution Summary running non stop 10.22

Hello raara,


The purge flows use a lock in order to avoid them run twice at the same time. You can try removing the lock from the lock from OO_RUNTIME_VALUE_STORE table. Also, we encourage the use of the purge scripts available on this link: https://marketplace.microfocus.com/itom/content/oo-database-maintenance



Carlos Rojas
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
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.