SharePoint 2010: Search sorting with text properties problem


In SharePoint 2010 if you configure some text properties, or even properties like title, to be used for sorting on search results, you might end up with an error like:

error exception from hresult: 0x80040e60

Solution:

The solution is to change the setting in the Managed Property Storage setting of the properties in question, and then perform a full crawl.

Capture

This solve my problem and the error disappeared.

What is the cause?

Aparently the setting of this option is directly linked the MaxCharactersInPropertyStoreIndex internaly, and for those that would like to dig a bit more, you can analyse the source code of the ManagedProperty.aspx page and understand the internally Sharepoint is performing a check that will fail if the setting is not to use the “Reduce storage requirements for tet properties by using a hash comparison

You can check more on this issue and solution from the following links:

https://joaodev.wordpress.com/2010/07/04/sorting-by-text-properties-in-moss-2010-requires-checking-the-option-reduce-storage-requirements/

https://social.technet.microsoft.com/Forums/sharepoint/en-US/c7558c57-c5a8-4bc2-b2a9-14ff4d5d1baf/sharepoint-2010-server-search-fulltextsqlquery-issue-with-like?forum=sharepointgeneralprevious

 

 

Computer developer/consultant from Portugal. You can find me at ricardo.magalhaes@gmail.com

Tagged with: ,
Posted in Sharepoint, Sharepoint 2010

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: