Dondon22 Respected Contributor.
Respected Contributor.
585 views

OO 10.70 - OO_RUNNING_EXECUTION_PLANS table, is this cleared after a flow finished running?

Hi!

OO 10.70

Is table OO_RUNNING_EXECUTION_PLANS cleared after a flow finsihed executing or this table will keep on accumulating?

TIA, Don

In IT there is no Magic, just Logic ^_^
0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

Re: OO 10.70 - OO_RUNNING_EXECUTION_PLANS table, is this cleared after a flow finished running?

Hi Don,

In 10.70 (and earlier versions) the OO_RunningExecution_Plans table is not cleared and should not be cleared manually since those plans may be involved ina ctive executions or may be reused for new flows. As such deleting data from this table is risky and may lead to your environment becoming unable to execute flows due to missing execution plans. 

Until further notice from support do not delete data from this table.

Regards,

Vlad

Dondon22 Respected Contributor.
Respected Contributor.

Re: OO 10.70 - OO_RUNNING_EXECUTION_PLANS table, is this cleared after a flow finished running?

Thanks Vlad... I am monitoring this table starting now... because this is the cause of my application mishap the past few days... it was solved after truncating this table... but of course it comes with a precondition and some steps to take.... you are correct, DO NOT just TRANCATE this table wihout coordination with the support team...

In IT there is no Magic, just Logic ^_^
0 Likes
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.