Create a Post
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Advisor

How to purge or clean smart even database in R77.30

Jump to solution

Hi Team,

Does anyone know how to purge the old entries from postgrsql DB? My reports are stopped and I am seeing below error in logs

 

[4 Sep 9:40:32][SVRServer] CRepAutoMaintQueueItem::HandleCapacityRule: low 70, high 80
[4 Sep 9:40:32][SVRServer] CRepAutoMaintQueueItem::HandleCapacityRule: Max size 199229440, currentSize 144754599
[4 Sep 9:40:32][SVRServer] CRepAutoMaintQueueItem::HandleCapacityRule: Percentage 72
[4 Sep 9:40:33][SVRServer] Database operation failed with error code 1.

[4 Sep 9:55:31][SVRServer] CRepAutoMaintQueueItem::HandleCapacityRule: low 70, high 80
[4 Sep 9:55:31][SVRServer] CRepAutoMaintQueueItem::HandleCapacityRule: Max size 199229440, currentSize 144778679
[4 Sep 9:55:31][SVRServer] CRepAutoMaintQueueItem::HandleCapacityRule: Percentage 72
[4 Sep 9:55:32][SVRServer] Database operation failed with error code 1.

 

[CPSEMD 20875 4122691264]XXXXXX[4 Sep 10:02:24] Current database size [33520868] has already reached database capacity [33520868].
[CPSEMD 20875 4069411728]XXXXXX[4 Sep 10:02:33] Current database size [33520868] has already reached database capacity [33520868].
[CPSEMD 20875 4069411728]XXXXXX[4 Sep 10:02:33] DB Is Full - stop Writing !!!
[CPSEMD 20875 4048432016]XXXXXX[4 Sep 10:02:33] Current database size [33520868] has already reached database capacity [33520868].
[CPSEMD 20875 4048432016]XXXXXX[4 Sep 10:02:33] DB Is Full - stop Writing !!!

1 Solution

Accepted Solutions
Highlighted
Champion
Champion

You can enlarge it if you want. See sk124432: SmartEvent does not show new events:

  1. Navigate to the Policy tab on SmartEvent.
  2. Expand General Settings.
  3. Increase the maximum database size to a value as required under Database Maintenance.
  4. Install the Event policy.

To remove stale unprocessed event from SmartEvent DB, consult sk60080: Disk space tips and tricks for SecurePlatform / Gaia / IPSO / Linux OS

And to get rid of all old data:

sk66575 - How to remove delete an Analyzer or SmartEvent database

View solution in original post

1 Reply
Highlighted
Champion
Champion

You can enlarge it if you want. See sk124432: SmartEvent does not show new events:

  1. Navigate to the Policy tab on SmartEvent.
  2. Expand General Settings.
  3. Increase the maximum database size to a value as required under Database Maintenance.
  4. Install the Event policy.

To remove stale unprocessed event from SmartEvent DB, consult sk60080: Disk space tips and tricks for SecurePlatform / Gaia / IPSO / Linux OS

And to get rid of all old data:

sk66575 - How to remove delete an Analyzer or SmartEvent database

View solution in original post