cancel
Showing results for 
Search instead for 
Did you mean: 

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
brentil
Level 12
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.

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?

McAfee Employee dboyd
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.

Member Rewards
McAfee Community rewards active and helpful members just like you. Click here to take a look at the first community members who received a special reward and were recognized by McAfee leader, Aneel Jaeel, for their participation and trusted knowledge in the community.