Microsoft.Office.Server.Search.Query.KeywordQuery.Execute() issue

[Bart X. Tubalinal]

When I use the KeywordQuery.Execute() function to do a search against a
numeric managed property (ex/ KeywordQuery.QueryText = "RecordID:1020"), I am
getting a COMException. In addition, the following events are recorded in the
event log:

-------------------------
Event Type: Error
Event Source: Office Server Search
Event Category: Search service
Event ID: 10040
Date: 4/22/2008
Time: 10:31:47 AM
User: N/A
Computer: RIDEV-SP12
Description:
The last query machine has been taken out of rotation. Check previous event
logs to determine cause. Propagation may be necessary. Component:
7711f79d-e019-408c-8c01-6d88c5cae639


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
-------------------------
Event Type: Error
Event Source: Office Server Search
Event Category: Search service
Event ID: 10038
Date: 4/22/2008
Time: 10:31:47 AM
User: N/A
Computer: [...]
Description:
Query machine '[...]' has been taken out of rotation due to this error:
Values of this type are not turned into strings necessary to generate scope
information. The item will not be locatable in all of the appropriate scopes
but this is not a serious error. 0x80044100. It will be retried in 15
seconds. Component: 7711f79d-e019-408c-8c01-6d88c5cae639


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
---------------------------------------------

What is causing this issue? When I use the KeywordQuery.Execute() function
with a search against a text property, everything works fine.

[Bart X. Tubalinal]

Just an FYI to anyone who comes across this: for some reason, this only
happens when the numeric managed property has the setting "Allow this
property to be used in scopes" turned on. When I have that unchecked for the
property, the query works fine. Check it, and the query crashes. Go figure.

Post by Bart X. Tubalinal
When I use the KeywordQuery.Execute() function to do a search against a
numeric managed property (ex/ KeywordQuery.QueryText = "RecordID:1020"), I am
getting a COMException. In addition, the following events are recorded in the
-------------------------
Event Type: Error
Event Source: Office Server Search
Event Category: Search service
Event ID: 10040
Date: 4/22/2008
Time: 10:31:47 AM
User: N/A
Computer: RIDEV-SP12
The last query machine has been taken out of rotation. Check previous event
7711f79d-e019-408c-8c01-6d88c5cae639
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
-------------------------
Event Type: Error
Event Source: Office Server Search
Event Category: Search service
Event ID: 10038
Date: 4/22/2008
Time: 10:31:47 AM
User: N/A
Computer: [...]
Values of this type are not turned into strings necessary to generate scope
information. The item will not be locatable in all of the appropriate scopes
but this is not a serious error. 0x80044100. It will be retried in 15
seconds. Component: 7711f79d-e019-408c-8c01-6d88c5cae639
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
---------------------------------------------
What is causing this issue? When I use the KeywordQuery.Execute() function
with a search against a text property, everything works fine.

[s***@gmail.com]

Hey Bart,

I had this same problem with FullTextSqlQuery and changed the property you mentioned. It solved my error.

Here's the error I received:
System.Runtime.InteropServices.COMException (0x80044100): Exception from HRESULT: 0x80044100 at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at Microsoft.Office.Server.Search.Query.FullTextSqlQuery.Execute() at SRRSearchResults.SRRSearchResults.returnResults(String strSQL)>>

Yes, it was for SP2007. Some clients still use it.

Thanks for posting this solution.

-Dave Sobiecki