Access official resources from Carbon Black experts
126.96.36.1993 (P15) and 188.8.131.529 (P16)
Events, that should have been pruned by the DailyPrune Task based on the Event Log Management settings, are still showing in the Bit9 Console.
The following query will show the count of events:
select count(*) from Events (nolock)
The following query will show the minimum timestamp for events that exist in the database:
select min(ReceivedTimestamp) from eventsGUI (1033)
This will happen only on versions 184.108.40.2063 (P15) and 220.127.116.119(P16).
The ProcessDailyStats stored procedure refers to a DB table that does not exist in this version and therefore fails to execute.
Being the first stored procedure to execute on the DailyPrune task, it stops the entire task execution, without logging additional errors.
To resolve the issue, choose one of the following options:
- Upgrade to the latest version of 7.0.1 or 7.2.
- Recreate the ProcessDailyStats stored procedure in the das database, using the attached sql script: