cancel
Showing results for 
Search instead for 
Did you mean: 

epo upgrade 5.10 problem with table fragmented

Jump to solution

Hi,

 

During PIA  i've got many table fragmented over 30%.

Following KB87769 with "All" option from ePO (https://<ePO_system_IP_address>:8443/remote/EPOCore.RebuildIndexesCommand?mode=1&table=All) with success I'm still getting only 1 table fragmented 93%.

Table name: IX_EPExtendedEventMT_TargetHash

I run the command also from sql MSM

EXEC EPOUtil_FetchIndexesToBeRebuildAndRebuild 1, IX_EPExtendedEventMT_TargetHash, 0 

But PIA continue to show table is fragmented.

Any suggestion?

 

 

1 Solution

Accepted Solutions
Highlighted

Re: epo upgrade 5.10 problem with table fragmented

Jump to solution

We had to use the attached script in KB67184 to get past this problem. 

4 Replies
McAfee Employee hem
McAfee Employee
Report Inappropriate Content
Message 2 of 5

Re: epo upgrade 5.10 problem with table fragmented

Jump to solution
How to execute a command to rebuild indexes after upgrading to ePolicy Orchestrator 5.9
Technical Articles ID:   KB87769
 
KB is for rebuild indexes after upgrading ePO. Before upgrade, please follow #: KB67184
 
Contents of KB can be accessed after registering to portal.
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?please select Accept as Solution in my reply and together we can help other members?
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 3 of 5

Re: epo upgrade 5.10 problem with table fragmented

Jump to solution

If you have run the reiindex script from our kb that you were given and you still get the warning, then you can still proceed with the upgrade.  It will not prevent the upgrade.  Highly fragmented databases will just take longer, but it won't cause it to fail necessarily, depending on the degree of fragmentation.  It could cause deadlocks in some circumstances.  The defrag script will only reorganize larger tables with fragmentation over 30%, so there may show some smaller tables with high fragmentation.  That is fine.

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?

Highlighted

Re: epo upgrade 5.10 problem with table fragmented

Jump to solution

We had to use the attached script in KB67184 to get past this problem. 

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 5 of 5

Re: epo upgrade 5.10 problem with table fragmented

Jump to solution

Good deal, that is what it is for.

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
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • Visit: Business Service Portal
  • More: Search Knowledge Articles
  • ePolicy Orchestrator Support

    • Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center