Property doesn’t exist or is used in a manner inconsistent with schema settings.

Posted on

Today, I had this on my enterprise environment which was not easy to figure out.

All our environments should be the same, but apparently it was not the case for the test environment.

Because we are trying to align together all our environments, we backed up one content database from prod and restore it into the test environment, and one of the pages didnt work showing the error: Property doesn’t exist or is used in a manner inconsistent with schema settings.

This page has a content search webpart with a very easy query:

contentclass:”STS_ListItem”  {SearchBoxQuery} ParentLink:”*opportunityinfo*”

 

As you can see the query is using OOTB managed properties, then I thought, wtf, I am screwed up, I checked the ULS logs and I saw:

 

SearchServiceApplicationProxy::Execute–Error occured: System.ServiceModel.FaultException`1[Microsoft.Office.Server.Search.Administration.SearchServiceApplicationFault]: SortList (Fault Detail is equal to Microsoft.Office.Server.Search.Administration.SearchServiceApplicationFault).
Getting results failed: SortList
Failed to get document content data. System.ComponentModel.Win32Exception (0x80004005): Cannot complete this function at Microsoft.SharePoint.SPSqlClient.GetDocumentContentRow(Int32 rowOrd, Object ospFileStmMgr, SPDocumentBindRequest& dbreq, SPDocumentBindResults& dbres)

Could not get DocumentContent row: 0x80004005.

SearchServiceApplicationProxy::GetUpdatedQueryParameterSpecifications–Proxy Name:Search Service Application Proxy EndPoint: http://be-xxxxx:32843/69cb3b7380164049ba43d8679204fb85/SearchService.svc

 

From the ULS Logs, all entries were high except Getting results failed: SortList, so I immediately checked the SORTING tab. And there it was.  The sort field was empty, why? because the managed property did not exist on the test environment.

 

I created the managed property and voila!!!, I fixed the problem!

 

I am a genius!

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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