FullTextSearchQuery 如何与 SharePoint 2010 和 FAST Search Server 配合使用？

发布于 2024-09-13 04:36:15 字数 1527 浏览 20 评论 0原文

我刚刚安装了一个测试环境，其中 SharePoint 2010 和 FAST Search Server 作为默认搜索服务应用程序。从一些测试内容开始，并使用 std 执行了一些搜索。 SharePoint GUI - 到目前为止一切都很好。

现在我想使用 Microsoft.Office.Server.Search.Query.FullTextSqlQuery 类执行更复杂的查询，事情变得很糟糕。当我尝试访问搜索返回的 ResultTableCollection 对象时，出现异常。

这是我尝试运行的 PowerShell 脚本：

$site = New-Object Microsoft.SharePoint.SPSite "http://moss"
$kq = New-Object Microsoft.Office.Server.Search.Query.FullTextSqlQuery $site
$kq.ResultTypes = [Microsoft.Office.Server.Search.Query.ResultType]::RelevantResults
$kq.RowLimit = 5
$kq.QueryText = "SELECT Title, Url"
$resultTableCollection = $kq.Execute()
$relResultTable = $resultTableCollection.Item([Microsoft.Office.Server.Search.Query.ResultType]::RelevantResults)

And this is the exception (thrown by the last line of code above):
The given key was not present in the dictionary.
System.Collections.Generic.KeyNotFoundException at System.ThrowHelper.ThrowKeyNotFoundException() at
System.Collections.Generic.Dictionary`2.get_Item(TKey key) at
Microsoft.Office.Server.Search.Query.ResultTableCollection.get_Item(ResultType requestedType)

当我使用 std 执行搜索时，相同的脚本可以完美地工作。 SharePoint 搜索服务应用程序。我在这里找到了一篇相关帖子指出查询结果的安全调整可能是我的问题的根源。但是，我看不出这与我的环境有什么关系，因为我的 FAST 服务应用程序的服务帐户在 AD 上肯定拥有足够的权限。

有什么建议吗？

原文

I just installed a testing environment with SharePoint 2010 and FAST Search Server as the default search service application. Started with some test content and executed a few searches using the std. SharePoint GUI - everything fine so far.

Now I want to execute a more complicated query using the Microsoft.Office.Server.Search.Query.FullTextSqlQuery class and things get nasty. I get an exception when I try to access the ResultTableCollection object returned by my search.

This is the PowerShell Script I'm trying to run:

$site = New-Object Microsoft.SharePoint.SPSite "http://moss"
$kq = New-Object Microsoft.Office.Server.Search.Query.FullTextSqlQuery $site
$kq.ResultTypes = [Microsoft.Office.Server.Search.Query.ResultType]::RelevantResults
$kq.RowLimit = 5
$kq.QueryText = "SELECT Title, Url"
$resultTableCollection = $kq.Execute()
$relResultTable = $resultTableCollection.Item([Microsoft.Office.Server.Search.Query.ResultType]::RelevantResults)

And this is the exception (thrown by the last line of code above):
The given key was not present in the dictionary.
System.Collections.Generic.KeyNotFoundException at
System.ThrowHelper.ThrowKeyNotFoundException() at
System.Collections.Generic.Dictionary`2.get_Item(TKey key) at
Microsoft.Office.Server.Search.Query.ResultTableCollection.get_Item(ResultType requestedType)

The very same script works perfectly when I execute the search using the std. SharePoint Search Service application. I found one related post here that stated the security trimming of the query results could be the source of my problems. However, I cannot see how this should be relevant in my environment since the service account of my FAST Service Application definitely has sufficient permissions on the AD.

Any suggestions?

分享到QQ

分享到微博