Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Absent Member.. ArielSO Absent Member..
Absent Member..
1379 views

Delete executions workflows records

Hi all!

 

 

Is posible  delete  the workflows execution records into history tab?

 

 

 

Regards....

0 Likes
3 Replies
Absent Member.. jake96 Absent Member..
Absent Member..

Re: Delete executions workflows records

DMA utilizes an Oracle database to store execution data.  With basic Oracle database administration skills you can manipulate the database.  Before making any changes to the Oracle database DMA depends on you should ALWAYS backup the database first!

 

Attached is a simple SQL script provided as an example that will purge DMA execution data from the database a set number of previous days.  Currently the number of days specified is the previous 90 days.  To change the number of days, modify the 90 found in all the entries (SYSDATE - 90) to the number of days you would like to purge.

 

The script purges the entries you will see in the history tab and the detailed run data in the database.  As such it can significantly reduce the size of a mature DMA database as well.

 

Instructions:

 

Save the attached file as /tmp/DMAHistoryPurgeScript.sql

 

Next use sqlplus to log into the DMA oracle database as DMA user.  You can find the Oracle database SID and user in the file /opt/hp/dma/server/tomcat/conf/Catalina/localhost/dma.xml.  Look for the jdbc connection string and username  e.g. jdbc:oracle:thin:@myhost.com:1521:DMA10 username="DMA10USER"

 

At the sqlplus command line execute the sql script file file

 

SQL> @/tmp/DMAHistoryPurgeScript.sql

 

SQL command output is logged to the file /tmp/DMAHistoryPurge.txt

Tags (4)
0 Likes
Absent Member.. ArielSO Absent Member..
Absent Member..

Re: Delete executions workflows records

Thanks  for your help, the rows were erased successfully.

 

regards....

0 Likes
Absent Member.. TPRE Absent Member..
Absent Member..

Re: Delete executions workflows records

The script attached is similar scripts which are provided with the software.  E.g. OO purge, etc.  Is there an official supported script provided by HP?

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.