I am using a FullTextSqlQuery to grab some data from a SharePoint instance. Initially I had a fairly simple where clause in which I filtered the results by the content type and everything worked fine.

I then tried to add some date filtering which added a condition like:

 AND mypublishstartdate <= '11/9/2011'

to the end. Unfortunately I am now getting the error:

Error HRESULT E_FAIL has been returned from a call to a COM component.

Exception Details: System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089]]: Error HRESULT E_FAIL has been returned from a call to a COM component.

Does anyone know what I am doing wrong here?

2 Answers 2


Do you have a managed property called mypublishstartdate which has a crawlable property mapped to it?

  • Yes I have that Nov 9, 2011 at 20:19
  • Try formatted your date in Year to Day format, then. YYYY-MM-DD.
    – James Love
    Nov 9, 2011 at 20:22
  • No more errors! Not getting any records now, but I can figure that out. Thanks! Any idea why that fixes it? Nov 9, 2011 at 20:27
  • It's the format datetimes are stored in the database, Year to second, YYYYMMDDTHHmmssZ (also known as ISO8601).
    – James Love
    Nov 9, 2011 at 20:35
  • Awesome, you're the man James! Nov 9, 2011 at 20:57

In my case, recycling the application pool where search was running fixed this issue

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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