CSA - Event database too big

Unanswered Question
Feb 6th, 2008
User Badges:

Hi. The CSA (v4.5) log file is displaying this message:


'The event database now contains approximately 18000001 events. This is in danger of exceeding the configured limit. In order to preserve correct operation, events of priority Alert and below will not be logged. Since the last report of this type, 1 events have not been logged. Please purge the event database as soon as possible.'

When I go to the Database Maintenance page it reports that there is plenty of disk space (22GB) and that there are no recommendations. There is therefore no option available to purge any records.


Does anyone know how to purge the log file in this situation?


Thanks


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
tsteger1 Wed, 02/06/2008 - 10:17
User Badges:
  • Red, 2250 points or more

In CSA 5.2 you can look at the Events>Event Managing Tasks>Event Insertion Task.


That contains the thresholds where it will stop logging certain events.


I don't know if 4.5 has this feature.


You could delete all alert events older than X days and see where that gets you.


Tom

mln.01 Thu, 02/07/2008 - 06:35
User Badges:

Hi Tom,

Thanks for this. No such feature on v4.5 unfortunately. Question, how to you delete the log files??

tsteger1 Thu, 02/07/2008 - 09:23
User Badges:
  • Red, 2250 points or more

Use 'event sets' to either create or modify an event set to show all events older than X days.


Once you have that, you can use it to view and delete all events matching the criteria.


Tom

Actions

This Discussion