Tag Archives: Usage and Health Data Collection

No Usage and Health data available

Problem

You enable the Usage and Health Data collection service but no data is displayed when you try to access it via SharePoint Diagnostic Studio.

Solution

Check that the Health Logging Schedule and Log Collection Schedule jobs are not disabled.

  1. Open Central Administration -> Monitoring -> Reporting -> Configure usage and health data collection
  2. Click on Health Logging Schedule followed by Log Collection Schedule

The jobs that you want to ensure are not disabled are:

Comments ( 0 )

Event 6398 Could not find stored procedure ‘dbo.Search_GetRecentStats’

Problem

You get the following errors in the event log on your SharePoint server.

Event ID: 6398

The Execute method of job definition Microsoft.Office.Server.Search.Monitoring.HealthStatUpdateJobDefinition (ID 9cb6be54-0384-4c6e-abfc-c2f25621a3ed) threw an exception. More information is included below.

Could not find stored procedure ‘dbo.Search_GetRecentStats’.

Event ID: 5586

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure ‘dbo.Search_GetRecentStats’.

Solution

The first thing to check would be whether Usage and Health data collection is enabled on your farm. To enable it:

  • Open Central Administration -> Monitoring -> Configure Usage and Health Data Collection
  • Ensure that Enable usage data collection and Enable Health data collection is ticked.
  • Select the events you wish to log.
  • Configure the Health Logging and Log Collection schedules.
  • Set the name of the database server and database name.

Give it some time and see if the problem is resolved, otherwise try restarting the SharePoint Timer Service on the server(s).

If this still does not work and you have already enabled the Usage and Health Data Collection service application. Try the following:

  • Turn off the Usage and Health Data Collection, unchecking both ‘Enable usage data collection and ‘Enable health data collection’.
  • Restart the SharePoint 2010 Timer service on all your SharePoint servers.
  • Turn the Usage and Health Data Collection back on.
Comments ( 0 )

Event 6398 and 5586 SharePoint Foundation

Problem

Event logs were getting filled with the following errors:

Event 5586, SharePoint Foundation

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure ‘dbo.Search_GetRecentStats’.

Event 6398, SharePoint Foundation

The Execute method of job definition Microsoft.Office.Server.Search.Monitoring.HealthStatUpdateJobDefinition (ID 3ed3dbdc-bbc4-45b6-8e84-449cdd2997f4) threw an exception. More information is included below.

Could not find stored procedure ‘dbo.Search_GetRecentStats’.

Solution

I tried the following without any success (although it has worked for some).

  1. Go to Central Administration -> Manage Service Applications -> Usage and Health Data Collection Service Application -> Uncheck everything. Restart the Timer Service. Re-check everything.
  2. Recreate the Usage and Health Data Service Application. Delete the Service Application in Central Administration and re-create it using the PowerShell command: New-SPUsageApplication -name “Usage and Health Data Collection Service Application” -database server “dbserver” -databasename “dbname”.
  3. Check that the Timer Job service account has sufficient permissions to the UsageAndHealthDataCollection database.

What worked:

  1. Go to Central Administration -> Monitoring -> Review job definitions
  2. Look for the job: Search Health Monitoring – Trace Events and see when it was last run. Chances are the job is set to ‘Disabled’ and never ran.
  3. Enable the job and click on ‘Run now’.
  4. The errors should stop appearing in the event log.

Cause

The Search Health Monitoring – Trace Events jobs creates the stored procedures in the UsageAndHealthDataCollection Database needed to run the job definition Microsoft.Office.Server.Search.Monitoring.HealthStatUpdateJobDefinition job.

Comments ( 4 )

Usage and Health Data Collection Proxy Stopped

Problem

Usage and Health Data Collection Proxy is Stopped and you need to restart it.

Solution

Run SharePoint Management Shell and issue the following powershell commands:

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

Comments ( 0 )