Event IDs 6398 and 5586 – Could not find stored procedure ‘dbo.Search_GetRecentStats’

While setting up SharePoint 2010 farm, after provisioning Search Service application, you may find the following Event IDs being logged into Windows Event Viewer. Search and indexing still may work.

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’.

Most probably this is because ‘Health Data Collection’ service is not enabled. To enable this service, go to ‘Central Admin > Monitoring > Configure usage and health data collection’ and check both ‘Enable usage data collection’ and ‘Enable health data collection’ check boxes. Reset IIS and SPTimer.

Note: If the event IDs are logged into event viewer and both the above services are already enabled, disable them first, reset IIS and SPtimer, enable them and reset IIS and SPtimer again.

Microsoft Baseline Security Analyzer

For server and application administrators who need to install MS Security patches manually from Windows Update on their servers, the Microsoft Baseline Security Analyzer is useful tool. It can check local or multiple remote computers for security vulnerabilities and other administration issues. It gives a detailed report on missing security updates and related KB articles after scanning . The tool will compare the updates with the organization’s Windows Server Update Services (WSUS) server and shows approval status within the report. Find more details at Microsoft website.

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {000C101C-0000-0000-C000-000000000046} – SharePoint 2010

This error is being logged into the System event logs in Event Viewer due to inadequate permission for the farm admin account on the DCOM component 000C101C-0000-0000-C000-000000000046. In order to change the permission settings, perform the following steps.

  1. Open Component Service by clicking Start > Administrative Tools > Component Services.
  2. Navigate and expand the node Component Services > Computers > My Computer > DCOM Config.
  3. Right Click the sub node “000C101C-0000-0000-C000-000000000046” and select “Properties”.
  4. On the Properties dialog box, select Security tab. In most cases you will notice that the settings are grayed out. This is because the logged in user doesn’t have enough permissions on this component to change the settings. In order to provide this permissions, perform the steps described in next section “Change Component Service Owner and Permission”. You may need to restart the server after doing this.
  5. Once you set up the permission mentioned in previous step, in the Launch and Activation Permissions section in Security tab, select Customize option and click Edit.
  6. In the popup window, add the farm admin user account and check Local Launch and Local Activation permissions. The screen should look like this.
    image_thumb1
  7. Restart IIS and SP Timer. If possible, restart the server itself.

Change Component Service Owner and Permission

In the DCOM Config dialog box, you noticed that the settings are grayed out. In order to enable those settings, perform the following registry modification.

  1. Open Registry Editor by typing “regedit.exe” in Start > Run.
  2. Navigate and select the key “[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\{000C101C-0000-0000-C000-000000000046}]”
  3. Right click and select Permissions.
  4. In the popup windows, click Advanced.
  5. In the Advanced Security Settings windows, select Owner tab and change the owner to Administrators. Click OK to close the window.
  6. In the Permissions screen, select Administrators and check Full Control. Click OK to close the screen.
  7. Close the registry editor.

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} – SharePoint 2010

After completing a fresh install of SharePoint 2010, if you followed least privileged installation, you may notice the following error being logged into the System events in Event Viewer. This is because the farm admin account, on behalf of which the SharePoint timer service is running, doesn’t have adequate permission on the DCOM component “IIS WAMREG admin Service”. In order to fix this permission issue,

  1. Open Component Service by clicking Start > Administrative Tools > Component Services.
  2. Navigate and expand the node Component Services > Computers > My Computer > DCOM Config.
  3. Right Click the sub node “IIS WAMREG admin Service” and select “Properties”.
  4. On the Properties dialog box, select Security tab. In most cases you will notice that the settings are grayed out. This is because the logged in user doesn’t have enough permissions on this component to change the settings. In order to provide this permissions, perform the steps described in next section “Change Component Service Owner and Permission”. You may need to restart the server after doing this.
  5. Once you set up the permission mentioned in previous step, in the Launch and Activation Permissions section in Security tab, select Customize option and click Edit.
  6. In the popup window, add the farm admin user account and check Local Launch and Local Activation permissions. The screen should look like this.
    image
  7. Restart IIS and SP Timer. If possible, restart the server itself.

Change Component Service Owner and Permission

In the DCOM Config dialog box, you noticed that the settings are grayed out. In order to enable those settings, perform the following registry modification.

  1. Open Registry Editor by typing “regedit.exe” in Start > Run.
  2. Navigate and select the key “[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\{61738644-F196-11D0-9953-00C04FD919C1}]”
  3. Right click and select Permissions.
  4. In the popup windows, click Advanced.
  5. In the Advanced Security Settings windows, select Owner tab and change the owner to Administrators. Click OK to close the window.
  6. In the Permissions screen, select Administrators and check Full Control. Click OK to close the screen.
  7. Close the registry editor.

SharePoint 2010 Error: "Unexpected error in Silverlight Application"

Some of you  might have come across the error “Unexpected error in Silverlight Application” while trying to create new sites or lists in SharePoint 2010 especially with newly created web applications. Here is a simple fix.

  1. Navigate to Central Admin > Application Management > Manage Web Applications.
  2. Select the web application having the issue and click General Settings on the ribbon.
  3. Change Web Page Security Validation from Off to On. Click OK to close the window.