Managed Search Property not being returned in Search Results

10/22/2014

Symptom A

I have a managed metadata column 'VideoArea' tied to a Search Metadata Property named 'PuroCastVideoArea'. I am firing a full text query ( as below ). The problem is that the search service returns Metadata Property 'PuroCastVideoArea' only in the first case. IE for the second query, the results are returned but there is no PuroCastVideoArea node/data in it. Though in both the cases, rest of the custom properties like PuroCastVideoDescription etc is returned.  

Tried running full crawl and incremental crawls numerous times but to no avail.

Symptom B

only for some items did the query 2 below return the managed property..infact out of 50 odd elements, only for one item did the search return the metadata property. 

Though query 1 always and without fail, returned the managed property

FIX

Pretty simple, delete the Content source and create a new one. Simple but took me 2 days to figure it out

Query Returning Property

<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'> <Query> <Context> <QueryText language="en-US" type="MSSQLFT">SELECT Title, Path,PuroCastVideoDescription,PuroCastThumbNail,PuroCastDuration,PuroCastVideoArea, DocId FROM Scope() WHERE "Scope" = 'Videos' AND CONTAINS(PuroCastVideoArea, 'SharePoint') </QueryText> </Context> </Query> </QueryPacket>

Query not returning the property

<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>
    <Query>
        <Context>
            <QueryText language="en-US" type="MSSQLFT">SELECT TOP 12 Title, Path,PuroCastVideoDescription,PuroCastThumbNail,PuroCastDuration,PuroCastVideoArea, DocId FROM Scope() WHERE "Scope" = 'Videos'  ORDER BY "PuratosCreatedDate" DESC</QueryText>
        </Context>
    </Query>
</QueryPacket> 

 

Name

Email

WebSite