SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using the FullTextSqlQuery object to search results from my SharePoint 2010 server with a specific query.

When I order by the created date (a new metadata property I have created myself of the type datetime), it will throw the exception “Error HRESULT E_FAIL has been returned from a call to a COM component.”

To get around the exception I want to tick the checkbox of the property "Reduce storage requirements for text properties by using a hash for comparison" but for a datetime value it is greyed out.

Does someone have an answer?

share|improve this question

Something else in your query is causing the exception. As the checkbox description itself states, it only applies to text properties. Also, enabling this checkbox wouldn't allow you to order by in any case.

According to this TechNet article (emphasis mine):

In the "Optimize managed property storage section", select the "Reduce storage requirements for text properties by using a hash for comparison" check box if you only need this property to have equality/inequality comparisons. Leave the check box cleared if you need to enable other types of comparisons (such as less than, greater than, and order by).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.