Error in the Site Data Web Service - No results returned from Search

I found this error message in the Crawl Log of Search Administration settings in Central Administration site after getting a complaint from the user that they cannot find any results when performing a search on a particular site collection.  It happened after we performed a site migration from one SharePoint 2007 farm to another SharePoint 2007 farm running on two different domains with trust relationship.

The root cause of this error is corrupted SIDs in the UserInfo table of the site collection, which returns no search results.  And the steps to solve the issue are:

Welcome to My SharePoint Blog

I would like to dedicate this blog as a diary of the exciting and challenging things that I have experienced and encountered while implementing SharePoint projects for my clients. It has been more than four years since I delivered the first SharePoint 2007 project in 2006. A lot of challenging issues have been found and ironed out during this journey. With the release of SharePoint 2010, there will be much more exciting things ahead.

Welcome to this blog!