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

 

 

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

Create a free website or blog at WordPress.com.

Up ↑

%d bloggers like this: