Hi there,

I've noticed that the deleted objects and object instances stay in the Opalis DB causing the performance issues as the DB is now almost 3 GB because of that.

Is there any way how to remove these deleted objects and instances ? I was just thinking of deleting them manually creating the custom SQL query for that into the tables. But I was wondering why there is no simple out-of-the-box cleanup of this ?

Opalis  6.2.0.5167

Many thanks.

With kind regards,

Pavel Cakl

• Edited by Pavel Cakl Wednesday, April 04, 2012 1:05 PM

Hi Pavel,

You can run purging manually multiple times. TO see if it is really working or not, run a query listing all the biggest tables in a DB.

If purging is completely broken:

1. backup your Opalis DB

2. truncate the tables with historical data

Policyinstances                       

Objectinstances                     

Objectinstancedata    
optionally Events too

More advanced solution is to delete the entries to a specific point in time.

It has happened to me multiple times. The purging script is timing out when there is too much data in Opalis DB.
You probably want to monitor the size of your DB. YOu need to take action when it reaches 2 GB size.

• Edited by Roman Schachta Tuesday, April 10, 2012 10:54 AM ortography
• Marked as answer by Yog LiModerator Wednesday, April 11, 2012 10:33 AM