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

  • 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