cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

PA: Maintain Database Task in ePO

Started: PA - Policy Auditor Database Maintenance
7/27/15 6:15:16 PM   Database index maintenance beginning on indexes with fragmentation >= 30.0 percent. Stop processing after 8 hours.

Hi,

Has anyone experienced issues with this task in ePO? I have it setup to run on daily basis and it seems like it never goes over 0% and never completed. I feel it is kinda bugging down the server and i'm not sure if terminating it is a good idea, or if it even does get terminated in the back end  when I click terminate. I know what this task is for and how important it is. However, is there a workaround? I'm running ePO 5.1.1 and policy auditor 6.2

Thanks,

4 Replies
Highlighted
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 2 of 5

Re: PA: Maintain Database Task in ePO

Did you ever find a resolution to this, we have the same issue and the account used is a db_owner of the ePO DB.  Still happening in ePO 5.3.2 software.

Highlighted

Re: PA: Maintain Database Task in ePO

Yup, I have two failed tasks every night and they are PA: Maintain Database and PA: Get Index and Space Statistics

I figured I would try the performance optimizer and it says we have some highly fragmented indexes. Going to hand it over to my SQL team to defrag or rebuild those.

Highlighted

Re: PA: Maintain Database Task in ePO

How many indexes do you have <30%? Do you also have the maintenance task setup in SQL?

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

Re: PA: Maintain Database Task in ePO

These server tasks are deprecated:

  • PA: Maintain Database
  • PA: Get Index and Space Statistics

They will always fail in PA 6.2+. See KB85086.

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