SharePoint Search: Custom Managed Property Woes

So I was working on some custom search interfaces that my team had built and was getting the infamous “Property doesn’t exist or is used in a manner inconsistent with schema settings”.

Now usually this means that you’re trying to use a managed property without mapping it to a crawled property or before doing a full crawl after creating the managed property. Neither of these were the case for me.

In my case I was trying to search on a DateTime field, which I’d set up as a Managed Property called DocDate, and I’d decided to base the format of the search term off what SharePoint creates from the advanced search screen which is “Write>=02/03/2012”.

When I was looking for a known document in my corpus which should have a DocDate of 15/02/2012 using the search term “DocDate=15/02/25012” I was presented a familiar message, however I knew I’d wired up the Managed Property correctly.

Infamous_Error

So I downloaded the SharePoint Search Service Tool and tested another search to verify that my DocDate property was populated and getting returned, sure enough, it’s coming back in search results.

Managed_Property_Returned

After a bit of head scratching and cursing I hit upon the problem.

1033.

I was getting bitten by the fact that the only “English” installation of SharePoint anybody can use is actually American, and their horribly broken date format is used by the query engine despite the fact that the Search Centre site has the locale set to en-NZ. A quick change of query to use ISO date formatting and BOOM! I’ve got results!

Search_With_Results

In short, SharePoint will give you the “Property doesn’t exist or is used in a manner inconsistent with schema settings” error message when it couldn’t parse a Date.

Advertisements
This entry was posted in Configuration, Development, Search. Bookmark the permalink.

4 Responses to SharePoint Search: Custom Managed Property Woes

  1. shuteyes says:

    How did you change the query to use ISO date formatting?

    • gavinbarron says:

      I had a custom control re-directing to the search page with the query on the querystring
      I just changed the query I passed along from date=”15-02-2012″ to date=”2011-02-15″

  2. Sutha says:

    you don’t need ISO, if you have the patch http://support.microsoft.com/kb/2553040

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