Monday, April 23, 2012

Could not find stored procedure ‘dbo.Search_GetRecentStats’, Event ID 5586 and 6398

In one of my new farm, I noticed two errors repeated themselves in the Event log every minute... One Critical (Event ID 6398), another Error (Event ID 5586), both complaint the same thing:
 "Could not find stored procedure ‘dbo.Search_GetRecentStats’"

Then I found my solution from Andrew Toh SharePoint Adventures Site - Event 6398 and 5586 SharePoint Foundation

Health Data Collection is not enabled. Do the following to enable this service.

  • Central Admin > Monitoring > Configure Usage and Health Data Collection.
  • On the page, make sure the "Enable Usage Data Collection" and " Enable Health Data Collection" are checked. 

If they are checked, make sure you reset them (uncheck them, click OK, come back the recheck them). Then your problem should be solved... 

Some time, I wonder if I could ever solve this issue without other help... because both errors do not mentioned or indicated anything about Health Data Collection... 
So Thanks Andrew! 

Friday, April 20, 2012

Start SharePoint Central Admin Service in Powershell

The other day, instead of reset (Stop and then Start again) the Business Data Connectivity Service in Services on Server page, I accidentally stop the Central Administration Service (well we are all human...) So I turned to PowerShell again...

List all SharePoint Services on the Server


To Start and Stop a SharePoont service you need

Start-SPServiceInstance [GUID] -Confirm

Stop-SPServiceInstance [GUID] -Confirm

Or You can pipe the Service Name to filter the Type Name and confirm your action.

Get-SPServiceInstance | Where-Object {$_.TypeName –eq ‘Central Administration’} |  Start-SPServiceInstance -Confirm

This should save a day :)

Thursday, April 12, 2012

Remove SharePoint Service Application Pool

I have been monkeying with the Search Service Application for the last couple days. From create new, to delete, and then re-create new one again in a different name... Then I noticed, when I delete the Service Application, it does not delete the Service Application Pool that previously created or associated with it.

So the previous entries are still in the Service App Pool, and the Service App Pool list is getting longer. when I check the IIS, all I see lots of GUID entries in the Service App Pool... I am nervous of removing GUID in the Service App Pool from IIS without knowing the App Pool Name of the GUID.

Then I turned my search to PowerShell and found a proper solution to remove the Service Application Pool...

First list all the Service Applications with the following cmdlet 
Get-SPServiceApplicationPool | Select Id, Name

* You will need the Service App Pool Name when you are moving the Service App Pool in PowerShell, and the ID, when you remove the Service App Pool from IIS Manager.

Second, remove the Service Application in PowerShell


Finally, find the ID in IIS Manager Application Pool, and remove the guid entry from there, if there application associate with the app pool, IIS will stop you from removing the entry.

That's it... 
Note : This is not a problem in SharePoint, because the App Pool can be shared by other applications as well, so removal process will require additional care and love...

SharePoint 2010 Search Comparison

There were time I was asked to present the different version of Search in SharePoint, there tons comparison information in the web, but some of them breakdown too much for non technical / business user to consume, so I decided to simplify a version that is easy to read, also provide a link for more details only if user is interested.

A simplify comparison table of SharePoint Foundation Vs Standard Vs FAST

SharePoint Foundation 2010
SharePoint Server 2010
FAST Search 2010 for SharePoint
Basic site search
Visual Best Bets
Search Scopes
Search Enhancement Based on User Context
Crawl and Index Custom Properties
Property Extraction and Managed Properties
Query Federation
Query Suggestions
Similar Results
Sort Results on Managed Properties or Rank Profiles
Relevancy Tuning by Document or Site Promotions
Shallow Results Refinement
Deep Results Refinement
Document Preview (Word, Excel, Powerpoint)
Windows 7 Federation
People Search
Social Search
Taxonomy Integration
Multi-Tenant Hosting
Rich Web Indexing Support

From a more reliable source I found in TechNet - By Vedant Kulshreshtha


Tuesday, April 10, 2012

Configure Search in your Non Domain Standalone DEV Machine

If your SharePoint DEV environment is a non domain on a single machine (or a VM) like the one described in  my post about SharePoint 2010 standard/enterprise with SQL 2008 R2 on a single machine (standalone);

Your SharePoint Search in this DEV is likely not working, then I found a great post from Søren Nielsen, he created a very neat script that setup the Enterprise Search in your DEV environment "automagically"!

Follow the "Search Fix" section, you will find the handy script, and it work like a charm!

How to install a SharePoint 2010 Complete (Dev) Server without AD - By Søren Nielsen

Also check out
How to install and configure a standalone Sharepoint 2010 Server By Srikanth Nair

Many thanks to both Søren Nielsen and Srikanth Nair for Sharing the knowledge!

Deployment for SharePoint Server 2010

Found a series of SharePoint 2010 deployment option with instruction from Technet, those are common topic from SharePoint Administrators

Deployment and Installation
Search Configuration
Technet Complete Reference