Re: using the sharepoint search api from forms services

CraigW — Wed, 18 Nov 2009 15:02:57 GMT

Update to this. It actually doesn't work in forms services at all, but works fine in infopath itself.

Any ideas?

Craig

using the sharepoint search api from forms services

CraigW — Wed, 18 Nov 2009 12:36:54 GMT

Hi,

I am trying to use the search api in my infopath form. This works fine in infopath iteself, but does not work when the form is deployed to forms services.

I have upped the logging in sharepoint and get the following:

11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          Exceptions                    0 Monitorable <Exception><HR>0x80044101</HR><eip>2AA8BB77</eip><module>d:\office\source\search\ytrip\tripoli\common\crequest.cxx</module><line>1232</line></Exception> 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 High    CTripoliConnectionWrapper::SignalError with 0x80044101. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:139 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 High    SignalError 0x80044101 to DSPAP-001. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:1183 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 High    _LokErrorKind In: 0x80044101. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:1339 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Medium _LokErrorKind Out: 0x0, Type: 0. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:1355 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 High    LokSignalError with kind: 0, machine DSPAP-001. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:507 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Medium CTripoliConnectionWrapper::~CTripoliConnectionWrapper. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:109 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Medium CApplicationCache::ReturnTripoliConnection for machine DSPAP-001, latency: 4937 - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:933 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Medium Calling CTripoliConnectionPool::LokReturnConnection for machine DSPAP-001 with latency: 4937ms, maxLatency: 15.000000, and latencyDecay: 0.050000. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:463 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Medium Already too many tripoli connections in cache... this one will be released. - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:483 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Medium Best Latency is machine DSPAP-001 at 0.458658 vs. average of 0.458658. We will boost his weight by: 0.000000 - File:d:\office\source\search\ytrip\tripoli\icommand\qpcache.cxx Line:967 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Query Processor     0 Monitorable In CRootQuerySpec::Execute - caught exception: 0x80044101, translated to: 0x80044101, queryID 0x17d00006 - File:d:\office\source\search\ytrip\tripoli\icommand\qryspec.cxx Line:773 4889d8bb-78a9-49b7-9d84-5baaf681dee2
11/18/2009 12:29:30.54 w3wp.exe (0x1810)                       0x17D0 Search Server Common          MS Search Administration      0 High    Log Query: Scope in your query does not exist. 4889d8bb-78a9-49b7-9d84-5baaf681dee2

Has anyone tried this before with success? The error logged in the form is:

Microsoft.Office.Server.Search.Query.ScopeNotFoundException: Scope in your query does not exist.
   at Microsoft.Office.Server.Search.Query.FullTextSqlQuery.Execute()
   at EEBS_BID1.FormCode.SearchUserProfiles(SPSite site, String login, String displayName, String department)
   at EEBS_BID1.FormCode.UserSearch(Int32& resultCount)
   at EEBS_BID1.FormCode.<>c__DisplayClass2.<NameSearchBtn_Clicked>b__0()
   at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
   at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
   at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
   at EEBS_BID1.FormCode.NameSearchBtn_Clicked(Object sender, ClickedEventArgs e)

Of course, the scope exists fine. As I said, the same code works in the infopath client, as well as from a powershell script run on the server.

I have tried using RunWithElevatedPriveledges, with no success.

Worth noting, the WFE and application servers are on different hardware.

Any ideas?

Thanks,

Craig

Browser Forms

Re: using the sharepoint search api from forms services

using the sharepoint search api from forms services