Issue:
Unable to search for People within MOSS 2007. Specifically, the People Scope within your SSP Search Settings shows 0 people after successfully importing User Profiles from your LDAP service. I finally resolved the people search issue I have encountered since I first installed SharePoint, so I have decided to document it for someone else that might have the same issue. The main issue was that I could not search for people from SharePoint sites, however, there were no issues in importing User Profiles as indicated by over 3000 user profiles in the User Profiles of my shared service. When I went into the Search Settings, and viewed the Scopes of my SSP, I realized that I had 0 People included in my People Scope. I found several posts where people deleted and recreated the People scope, but that didn’t work for me. So, in an over simplification of what is going on, I tried to think about what SharePoint is doing:
- Importing User Profiles into user profile database
- Indexing the User Profiles to make them searchable
Okay, so it’s not an issue with the import, so SharePoint isn’t indexing the content properly; why?
- Did I have a domain account that didn't have the correct permissions to the database where the user profiles were imported? (Big Disclaimer: My friend Milan Gross recommended looking at permissions as a likely culprit, and while I don’t believe this was ultimately my issue, I would like to say that I have been diligent in following the SharePoint Administrator’s Companion)
- Did I configure something incorrectly?
- Did SharePoint configure something incorrectly?
- Is SharePoint broken?
The clue I found that pointed me in the right direction was in the crawl logs for the Local Office SharePoint Server sites under search settings. I found the following error message: sps3://servername:port#
Error in PortalCrawl Web Service A similar message was also in the windows application event log. This led me to a few posts online including this one by Sheetal Jain:http://office12.blogspot.com/2007/05/people-search-and-my-site-ssp.html While the post itself didn't solve me problem, it pointed me in the right direction, in that it mentioned the need to create a dummy site collection at the mysite root. As Sheetal put it, not having a site collection at the my site web application root caused a “stomach ache for SharePoint Indexer.” As a lessons learned, here are a few things I tried to modify based on different threads I found; none of which worked. After I made each setting change I re-imported all profiles, and performed a full crawl on Local Office SharePoint Server sites.
- Modified “sps3://servername:port#/” in Shared Services Administration: Shared Services > Search Settings > Content Sources > Edit Content Source of Local Office SharePoint Server Sites to “sps3://servername:port#/mysite”.
- Create Site Collection on the MySite web application root “/” managed path as a MySite Host under the Enterprise Tab of the Site Collecction Templates.
- This seems to be what Sheetal was referring to, but I seemed to have an issue with it in that I got a permission error when creating a site collection on the root of the web application. After the error I could not repeat the step of creating a My Site Host site collection on the root. I even went to delete the site collection on the root, but it wasn’t in the site collection list to delete, and the only kind of site collection SharePoint would let me create now was a site collection under the sites or personal managed paths. Oy!
- Delete the MySite “mysite” managed path. This did nothing, as expected, but was a last resort.
- Undid step 1.
- Changed MySite Personal Site Services provider location in SSP. a. I changed it from http://servername:port#/mysite/ to http://servername:port#/, as “mysite” is the Relative URL I entered when I created the SSP.
After none of these steps worked I started creating new Shared Service Providers, just to see what would happen. I haven’t played with SharePoint 2007 Administration too much and I was still a little reluctant to create a bunch of SSPs. DON’T BE! It is super easy to create them change web site associations, and delete them. It was almost fun ;-). When creating my first alternate SSP I left everything as the default setting, imported the user profiles, crawled the Local sites, and poof, User Profiles were indexed. I figured there was probably a permissions issue when I initially configured SharePoint, so I deleted the MySite under the new SSP and moved all the web applications from the old SSP to the new SSP, and poof, my indexed profiles were gone! Hm… What is happening? Several more SSPs later I narrowed it down to one setting, that appears to be throwing something off on SSP creation, which is the relative URL for the My Sites. Every time I created a SSP with a relative URL for the MySite web application the Indexer was not able to index the User Profiles. I was then unable to figure out what settings needed to be changed to get it to start working again.
So, it appears that ultimately I had the same problem as Sheetal where the SharePoint indexer is not able to index the imported User Profiles because it is not able to access sps3://servername:port#, however, I resolved it is very different.
Resolution:
1. I created a Brand new SSP
2. As always, I created a separate Web Application for the SSP Web Application and the My Site Location.
3. I left the Relative URL BLANK!
4. I made the new SSP the default SSP.
5. I moved all my existing Web Applications to the new SSP EXCEPT the old SSP Administration site host and the old MySite web application, as I could not resolve the issues with the old MySite web application.
This worked well for me because I was still testing a SharePoint installation and there were only two personal sites created; mine and one other user’s. This is probably not the best solution for someone that has already implemented SharePoint across an enterprise.
If anyone else knows of a better or simpler solution, I would love to know about it!
As this is my first MOSS 2007 Blog post, I can’t wait to look back on it a year from now and laugh at my MOSS naivety.