This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

OO flow chart

Hi, 

Could you please tell me in which table OO flow charts are stored (The chart that appears in central  when we enter an execution details),

and is it safe to truncate this table ?

Regards;

  • Suggested Answer

    0  

    There are several tables that store all execution related data:

    1. OO_STEP_LOG_* tables (STARTED, ENDED, BINDINGS , number of entries ~= 10 x NbofSteps),
    2. OO_EXECUTION_EVENTS_* tables (rolling tables - quartz job is running),
    3. OO_EXECUTION_STATES_* tables (rolling tables - quartz job is running),
    4. OO_DEBUGGER_EVENTS (its size grows if OO Studio remote debugging on a Central is used extensively),
    5. OO_EXECUTION_BOUND_INPUTS & _OUTPUTS (its size grows if very large inputs and outputs are used extensively).

    It is better to use OO Purge procedures.

  • 0 in reply to   

    First, Thanks for your answer  and for all details.

    But in my case, i do not want that users can see the chart of the current execution (See below). i want to discard the chart of the flow.

  • 0   in reply to 

    HI, instead of truncating the underlying stored execution data, why don't you restrict your users towards executing flow only through the end user OO SSX Portal. Of course if your OO flavor includes SSX as an option.

    HTH,

    Adi