Get rid of OpenQuery Failed with status ID: 0x800007d0 in ULS

After provisioning Search Application you might see a lots of errors in ULS:

mssearch.exe (0x13C0)                    0x1250 SharePoint Server              Unified Logging Service        9saa Unexpected OpenQuery Failed with status ID: 0x800007d0. QueryPath: \Search Gatherer Projects - SharePointServerSearch(Search_Service_Application_1_0_Portal_Content)\Transactions Completed. instanceHandle: 3.
mssearch.exe (0x13C0)                    0x1250 SharePoint Server              Unified Logging Service        9saa Unexpected OpenQuery Failed with status ID: 0x800007d0. QueryPath: \Search Gatherer Projects - SharePointServerSearch(Search_Service_Application_1_0_Portal_Content)\Transactions In Progress. instanceHandle: 3. 

To fix the problem follow the step below:

1. Fix Usage and Health Data Collection Service Application Proxy as described here: http://tristanwatkins.com/fixing-the-usage-and-health-data-collection-sa/
2. Check if an account of crawl component is a member of "Performance Monitor Users" local security group.

Fix Usage and Health Data Collection Service Application Proxy

1. start Sharepoint management shell as administrator
2. run the script:

$sap = Get-SPServiceApplicationProxy | where-object {$_.TypeName -eq “Usage and Health Data Collection Proxy”} $sap.Provision()
3. restart IIS

4. open Search Service Administration in SP Central Administration
5. click on Index Reset, then Reset Now
6. check the ULS if the error dissapeared.