Showing results for 
Search instead for 
Did you mean: 

ePO 4.5 flooding SQL DB

I am hoping someone else has seen this, I cannot find a resolution anywhere.

I stood up a new McAfee epo 4.5 server last Thursday after testing it in a virtual environment for several months with no issues.  I exported the system tree along with the system names from our production ePO 4.0 server to the newly built ePO 4.5 server.  Since my virtual test envronment was 4.5, I exported the policies and imported them into the new 4.5 server as well.  I then created a query to search for all unmanged system and built an automation task to install agents on all unmanaged systems.  I set the task to run every 4 hours and it was installing the agent on a few machines at a time and nothing more.  The task was stopping in less than a minute. So I went on and had a network guru incorporate the agent install into the logon script.  I got great results and thought we were on the way to great success.  When I got back to work Monday, the ePO DB was almost 43 GB.  The server was being flooded with 1095 events. Naturally, I turned off the event, but they kept coming. At that point, I had to kill all ePO services because it started to bog down other enterprise apps (HEAT, BES) that have DBs on the same SQL server.  I had the DBA restore the ePO DB from an earlier version after I changed the ports in ePO so the endpoints could not talk to ePO. I then went back in and made sure that the 1095 event was turned off and restored the ports so the endpoints could talk again. I understand that the endpoints were caching data while the services and ports were unreachable, however even after turning off 1095 and performing an agent wakeup, the events continue to flood in after almost 48 hours.  I have exercised every avenue possible including McAfee Gold Support with no end in site.  Does this sound like a case of cached data on endpoints that cannot get written fast enough, or something more serious?  Any input would be greatly appreciated.

1 Reply

Re: ePO 4.5 flooding SQL DB

If you mean this event

Access Protection (OAS)
ops.service.startwould deny create, would deny read, would deny write, would deny execute, would deny delete, would deny modify, would deny terminateN/A
Would be blocked by access protection rule  (rule is in warn-only mode) (%INFO%)

I would probably do the following:

1) Get access to a client where you got a lot of 1095 events from

2) Check the log c:\documents and settings\all users\application data\mcafee\desktop protection\accessprotectionlog.txt

Generally all cached events from agent can be deleted locally on the client by removing all files from c:\documents and settings\all users\application data\mcafee\common framework\events (should be all XML files). Also I would strongly advise to disable all access protection "warning" setting if not evaluation that rule - some rules (like the VMware ones) can generate really high amount of events (so ONE system generating 8GB of events in three weeks).

But I do not know why diabling the event via epo does not work - if evaluating this you could check the c:\documents and settings\all users\application data\mcafee\commonframework\events.ini (I cannot remember the correct file name, but it is an INI file). There the event 1095 should no be listed to report to epo.