Dondon22 Respected Contributor.
Respected Contributor.
434 views

OO 10.70 - Table OO_EXECUTION_STATE / OO_EXECUTION_STATES? is it safe to truncate?

Hi!

OO 10.70 build number 16

Is it safe to truncate these 2 tables?

OO_EXECUTION_STATE

OO_EXECUTION_STATES

TIA

Regards,

Don

In IT there is no Magic, just Logic ^_^
0 Likes
1 Reply
Outstanding Contributor.. JarodMB Outstanding Contributor..
Outstanding Contributor..

Re: OO 10.70 - Table OO_EXECUTION_STATE / OO_EXECUTION_STATES? is it safe to truncate?

I run the following in the event of some sort of system error which has led to a pile up of executed but not executing flows. 

TRUNCATE TABLE OO_FINISHED_BRANCHES
GO

DELETE FROM OO_SUSPENDED_EXECUTIONS
GO

TRUNCATE TABLE OO_EXECUTION_QUEUES 
GO

TRUNCATE TABLE OO_EXECUTION_STATE
GO

TRUNCATE TABLE OO_EXECUTION_STATES
GO

TRUNCATE TABLE OO_EXECUTION_STATES_1
GO

TRUNCATE TABLE OO_PAUSE_DATA
GO

DELETE FROM OO_RUNTIME_VALUE_STORE
GO

 

UPDATE OO_EXECUTION_SUMMARY SET STATUS = 'CANCELED', END_TIME=START_TIME WHERE STATUS IN ('RUNNING','PAUSED','PENDING_PAUSE','PENDING_CANCEL')
GO

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.