Micro Focus Expert
Micro Focus Expert
346 views

(OO) Support Tip: Purge scripts not cleaning all data

In 10.x there are several types of data stored.  The purge scripts clean the execution data.

To clean remote Debug data or audit data there are operation/flows.

 There are also flows to purge execution data but we do not recommend them over the purge scripts becuase they are multiple layers of abstraction and DB calls.  The purge scripts will be much more efficient

This post focuses on Debug data from Remote debugging sessions.

The action of Studio remote debug will create data in the OO_DEBUGGER_EVENTS table. A graphical ilustration is also available in the OO Central Database Health tab in later versions of OO 10.x. With multiple authors creating and debugging flows, this data will continue to grow unless purged periodically. To maintain the database and purge this data, OO recommends to run the flow: 
/HPE Solutions [1.x.y]/Library/Integrations/Hewlett-Packard/Operations Orchestration/10.x/Database/Purge Debug Events

However this flow is time consuming for large data.  If this has not been done on a regular basis one way to manage it is to run SQL commands to remove the data and then setup the flow to run in a scheduled manner in the future.

SQL Command:

TRUNCATE TABLE OO_DEBUGGER_EVENTS;

The data in that table is not used after a debug run ends. So performing the above command is fast and safe. Make sure OO Central Service is stopped while interacting directly with the database.

 

Labels (3)
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.