cancel
Showing results for 
Search instead for 
Did you mean: 
Nick_B
Level 11
Report Inappropriate Content
Message 1 of 4

Excessive Table Size for EPODataChannelDataMT

Dear McAfee Community,

We have a customer with an unusual issue whereby one of the tables in their ePO DB grows to ridiculous proportions - when I was discussing the issue with them today they reported this table to be about 300GB (122,211 rows). The table in question is EPODataChannelDataMT.

The issue they're experiencing is described in KB90920.

Below is the first scenario as described in the aforementioned KB:

KB90920 Query Extract - top.PNGExtract from KB90920

 And the results of that query are below:

EPOAgentHandlerDataChannelWQMT Query Only.PNGQuery Results

Their environment consists of about 5,000 managed endpoints (roughly 500 of which have Drive Encryption installed, v7.2.5), McAfee Agent 5.6.1 (mainly) and ENS 10.6.1. There are no reported issues of users being unable to login through the Pre-Boot Authentication (PBA) screen.

The ePO version is 5.10.0 Update 4 (applied recently). Previously they were on 5.3.2.

SQL version is 2016 (full version). Recovery model is Simple.

File growth is set to 200MB.

The SQL Server is a Shared one with around 70 or so other DBs residing there, some of which are not in use. No reported issues with the other DBs - that is, as long as the ePO server is rebooted daily, otherwise the other DBs are affected as the SQL server reaches breaking point and almost collapses.

Arithmetic Abort is set to True.

Auto close if off.

Collation is SQL_Latin1_General_CP1_CI_AS.

Also on the phone today the customer mentioned that this issue is not "new" as such and has been around in some form or other for a number of years - at least since 5.3.2 days.

The workaround they have in place is a scheduled task which reboots the ePO server on a daily basis, which usually (but not always) has the effect of shrinking the table back to normal size. Other times it only reduces partially in size, say back down to 24GB or so.

Looking forward to your thoughts guys!

3 Replies
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: Excessive Table Size for EPODataChannelDataMT

What version of epo? Check to see if the dbcleanup task is running properly - kb84114. First confirm you have that issue or not by following the workaround step 2. If you do have that issue, we should probably get the table truncated first before proceeding with kb84114. Attached is a script for that, but be sure to back up everything per kb66616 first and follow any commented instructions in the script. This would cover all the current versions of epo.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Nick_B
Level 11
Report Inappropriate Content
Message 3 of 4

Re: Excessive Table Size for EPODataChannelDataMT

Hi Caryn,

Sorry, the ePO info was buried a bit further down.

It's 5.10.0 Update 4, the very latest.

Highlighted
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: Excessive Table Size for EPODataChannelDataMT

That's ok, make sure to go through the steps I gave you then.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

More McAfee Tools to Help You

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