Dondon22 Respected Contributor.
Respected Contributor.
537 views

OO 10.70 - Table OO_EXECUTION_QUEUES is it safe to truncate?

Jump to solution

Hi!

OO 10.70 build number 16

Is it safe to truncate table OO_EXECUTION_QUEUES?

TIA

Regards,

Don

In IT there is no Magic, just Logic ^_^
0 Likes
1 Solution

Accepted Solutions
Outstanding Contributor.. JarodMB Outstanding Contributor..
Outstanding Contributor..

Re: OO 10.70 - Table OO_EXECUTION_QUEUES is it safe to truncate?

Jump to solution

Sent the same in response to a similar question - 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

2 Replies
Outstanding Contributor.. JarodMB Outstanding Contributor..
Outstanding Contributor..

Re: OO 10.70 - Table OO_EXECUTION_QUEUES is it safe to truncate?

Jump to solution

Sent the same in response to a similar question - 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

Dondon22 Respected Contributor.
Respected Contributor.

Re: OO 10.70 - Table OO_EXECUTION_QUEUES is it safe to truncate?

Jump to solution

Thanks for the response, after this step I truncated table OO_RUNNING_EXECUTION_PLANS and that solved the problem 🙂

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.