Showing results for 
Show  only  | Search instead for 
Did you mean: 
Former Member
Not applicable
Report Inappropriate Content
Message 1 of 4

Mcafee EPO Database Tables over 60 Million Rows.

Hi All,

Looking for some advice.

I am looking at upgrading our ePolicy Orchestrator from 5.0.1 to 5.3

After running the installer we got the error message advising us to view the KB79561.

After looking at the options and running the purge events and purged rolled up data tasks. We noticed this is either taking very long or not running correctly.

We have since looked at the SQL Database and noticed the following tables have a lot of rows.

EPOProductEvents 60 Million rows

OrionSchedulerTaskLogDetail 60 Million Rows

OrionSchedulerTaskLog 10 Million Rows

We have manually ran a script to clear this down which is working, however I would like to know what causing this to create so many rows and how to prevent it logging so much. From investigation we found its logging 5 events per second.

Has anyone has anything similar? or had any major issues upgrading with Tables of this size. Our MDF file is around 65 GB. and our log file is 100 GB



3 Replies

Re: Mcafee EPO Database Tables over 60 Million Rows.

Moved to ePO for faster support




Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 3 of 4

Re: Mcafee EPO Database Tables over 60 Million Rows.

you can create a servers task in ePO to purge older entries automatically. It might not include the server tasks log by default but you can include that

Level 9
Report Inappropriate Content
Message 4 of 4

Re: Mcafee EPO Database Tables over 60 Million Rows.

Try this:

McAfee KnowledgeBase - How to find large tables in the ePolicy Orchestrator database and purge event...

Check which events are doing this purge it and try to upgrade that DB is so big!

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community