Respected Contributor.
Respected Contributor.

(OO) Support Tip: Purge Execution Summary flow and OO_EXECUTION_STATES table

This environment was upgraded.  The Purge Execution Summary flow (HPE Solutions content pack) was used to delete old executions.  Following that, it was discovered that the OO_EXECUTION_STATES table was very large (more than 80 GB in size).  Why is this database table so large?  What may have caused this?  Is it possible to purge this database table and how to do so? 

Root cause:
Before the upgrade, the purging scheduled task was not stopped in a clean way during Central shutdown. As a consequence, it could have left the status column in the BLOCKED state. After restarting Central following the upgrade, any subsequent attempts of this scheduled job to execute will not run until the status changes from BLOCKED to WAITING. On the other hand, the BLOCKED status can be reset only by the job that has finished running but there was no such job running because of the reason mentioned above. The solution was to set the queueCleanerJob trigger in the OO_TRIGGERS table to status WAITING and restart the Central service. The queueCleanerJob was triggered and managed to clean the OO_EXECUTION_STATES table after some time.

Enhancement QCCR8C32968 Before upgrade, make sure purging scheduled task has been stopped cleanly has been submitted and can be viewed at https://softwaresupport.hpe.com/km/KM02753326

Labels (1)
0 Replies
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.