Google+

Search Crawl error: Value does not fall within the expected range

Leave a comment

March 9, 2015 by Ruaan Harmzen

Been facing an issue where the Search Service is not crawling a simple site collection in our SharePoint farm. Had a scratch through the crawl logs and found the following error:

sts4://myintranetsite/siteurl=sites/finance/siteid={42461088-3f26-4c2d-937e-c630c7033307}
The SharePoint item being crawled returned an error when requesting data from the web service. (The item was deleted because it was either not found or the crawler was denied access to it.
– Error from SharePoint site: Value does not fall within the expected range.)

This is caused by orphaned users in your site collection database. When SharePoint syncs with AD the deleted accounts\profiles are not always cleaned up properly by SharePoint. Not going into user profile sync in this post, so just jump next to solution:

Run the following update script on your site collection content db (if you are scared of the dark or believe in backups then maybe run as a select first):

Update UserInfo set tp_deleted=tp_ID where tp_SiteID=’42461088-3f26-4c2d-937e-c630c7033307′ and tp_Login in
(
Select tp_login from UserInfo where tp_SiteID=’42461088-3f26-4c2d-937e-c630c7033307′ and len(ltrim(rtrim(tp_systemid))) <25 and tp_deleted = 0
and tp_login not in (‘NT AUTHORITY\authenticated users’, ‘NT AUTHORITY\LOCAL SERVICE’,’SHAREPOINT\system’)
)

Essentially we are just disabling the orphaned users (excluding the system accounts). Rerun your crawl now and all should be fine

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: