Absent Member.. nanogueira Absent Member..
Absent Member..
970 views

OO DataBase Maintenance Procedures to Purge History of Data doesn't work

Hello,

 

We are trying execute the OO DataBase Maintenance Procedures to Purge History of Data.
But the Database continuous with the same size.
The procedures are execute with success, but they don't release space of the database.

 

Natali.

Labels (1)
Tags (1)
0 Likes
5 Replies
Absent Member.. daniel_daraban Absent Member..
Absent Member..

Re: OO DataBase Maintenance Procedures to Purge History of Data doesn't work

Hello Natali,

 

Can you please provide the OO version that you are using?

 

Also, can you please provide the database type you are running the scripts on?

 

If I understood correctly, the purging procedure removes the entries that you want to remove, but the actual db space is not reclaimed. Is that correct?

 

Thank you very much!

 

Best regards,

Daniel

0 Likes
Absent Member.. nanogueira Absent Member..
Absent Member..

Re: OO DataBase Maintenance Procedures to Purge History of Data doesn't work

Hello Daniel

 

The OO version is 10.20.

The Database is 

Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 

 

The procedure was executed successfully, but the data was not delete.

 

 

 

 

0 Likes
Absent Member.. daniel_daraban Absent Member..
Absent Member..

Re: OO DataBase Maintenance Procedures to Purge History of Data doesn't work

Hello Natali,

 

What parameters did you use to execute the procedure?

 

For ex(in my lab):

 

USE [OO1020DB] GO


EXECUTE [dbo].[OOPurgeHistory]
@PurgeExecutionsOlderThan = 90
,@PurgeExecutionsInBatchesOf = 1000
,@ShouldPurgeExecutionSummary = 0
,@verbose = 1
,@StopPurgingProcessAfter = 4
,@DeepClean = 0
GO

 

The above parameters will purge all the execution data that is older than 90 days. If all the data isn't older than 90 days, nothing will be deleted.

 

Best regards,

Daniel

 

 

0 Likes
Absent Member.. nanogueira Absent Member..
Absent Member..

Re: OO DataBase Maintenance Procedures to Purge History of Data doesn't work

Daniel,

 

We are using this configuration in the procedure:

 

USE [OO1020DB] GO


EXECUTE [dbo].[OOPurgeHistory]
@PurgeExecutionsOlderThan = 30
,@PurgeExecutionsInBatchesOf = 1000
,@ShouldPurgeExecutionSummary = 0
,@verbose = 1
,@StopPurgingProcessAfter = 4
,@DeepClean = 0
GO

 

And the Database there is data that is older than 30 days.

 

Natali.

0 Likes
Absent Member.. TimCrockett Absent Member..
Absent Member..

Re: OO DataBase Maintenance Procedures to Purge History of Data doesn't work

So, the purge will delete records from the database, but the database itself will generally remain the same size.  If you really have a need to shrink the database, you can find instructions here for MS SQL.

https://msdn.microsoft.com/en-us/library/ms189035.aspx

Also, if you do not purge execution summary data (,@ShouldPurgeExecutionSummary = 0), OO will still show a line item in the run history for all the runs, it just won't have any details if you click on it.

 

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.