Solution for “HRESULT: 0x80040E60” Error in SharePoint Search

By Namwar Rizvi - Last updated: Wednesday, September 22, 2010 - Save & Share - One Comment

If you are getting “Exception from HRESULT: 0x80040E60” error while executing FullTextSqlQuery then most probably it is due to your Order By column.  Make sure you use that property in Order By clause which is configured to have a single value in Manage Property configuration screen.

Make sure you have selected “Include values from a single crawled property based on the order specified option otherwise; you can not sort results by that property.

The reason behind this restriction is that logically sorting can be performed on objects who have single value which can be compared to other object’s value and then the precedence can be determined. On the other hand, if objects have multiple values then their precedence can not be determined.

Share
Posted in Debugging, How To, Search, Troubleshooting • Tags: , , , , Top Of Page

One Response to “Solution for “HRESULT: 0x80040E60” Error in SharePoint Search”

Comment from pakde
Time April 2, 2012 at 4:55 am

Hai, I’ve got this problem too for “Order By SiteTitle”. I’ve checked that SiteTitle Property is already in that condition.
So, How is that ?

Thanks

Write a comment