.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error while accessing the FullTextSqlQuery

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :SharePoint

I am getting the following error:

Could not load type 'Microsoft.Office.Server.Search.Query.FullTextSqlQuery' from assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.

Here is my code :

           string searchPhrase = "site";
            DataTable tbl = null;

            SPSite site = new SPSite("http://localhost:4444/");

            Microsoft.Office.Server.Search.Query.FullTextSqlQuery ftsq = new Microsoft.Office.Server.Search.Query.FullTextSqlQuery(site)
                QueryText = String.Format("SELECT Title, SiteName, Path FROM Scope() WHERE \"scope\"='All Sites' AND CONTAINS('\"{0}\"')", searchPhrase),
                //QueryText = String.Format("SELECT Title, SiteName, Path FROM Scope()", searchPhrase),

View Complete Post

More Related Resource Links

System.Messaging - Error accessing properties of remote private queues - "UnsupportedFormatNameExcep

I'm having some difficulty accessing private queues on a remote machine, but no trouble using remote public queues or private queues on a local machine. Calling: System.Messaging.MessageQueue.GetPrivateQueuesByMachine("machine"); ..succesfully returns the array of private queues on the remote machine.  However, trying to access nearly all of the properties on these MessageQueue objects returns: MessageQueueErrorCode: UnsupportedFormatNameOperation Message:"The specified format name does not support the requested operation. For example, a direct queue format name cannot be deleted." I have no trouble accessing queues created identically on the local machine using GetPrivateQueuesByMachine("."), plus accessing public queues using GetPublicQueuesByMachine("machine") also returns MessageQueue objects that are useable. The FormatName returned appears to be valid, as you would expect from queues retreived via GetPrivateQueuesByMachine().  e.g: FormatName:Direct=OS:machine\\private$\\example ..so I think the error message returned may be somewhat spurious. The permissions on the queues all appear to be set correctly.  I had even attempted allowing "Full Control" to "Everyone" on these queues as an experiment, with the same results. Any ideas for other things I might try? p.s. I am running Windows XP SP2, using .NET 2.

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

Error when accessing an InfoPath file on a file share

Some users get an error when they try to open an InfoPath (2007) file which is location on a file share.  The users getting the error are from our South America domain.  All users, regardless of domain, have the same permissions to the file share folder and they can open and save other files on that file share, txt file, Excel file, etc.  They get this error when trying to open the Info Path file:  "InfoPath cannot create a new, blank form.  InfoPath cannot open the form.  to fix this problem, contact your system administrator.  The query cannot be run for the following data source:SoftwareList"

Error accessing Search Settings and search returns 0 results

Quick summary - my MOSS 2007 server died. I brought up a new server, installed MOSS, service pack 1, service pack 2, created the new config database, then attached my existing content database (I have a separate physical server for the databases). After a few tweaks to get most of the other settings back in order, (most) everything seems to be working somewhat as it should except for Search. Whenever I try to access Search settings I get an error: "An error occurred during the processing of . The resource object with key 'S2SearchAdminDashboard_Title' was not found". I created a new SSP with it's own unique account for the service and app pool (read online that it should be different than SharePoint account because of the timer service conflicting with search), I tried copying the files (listed here: http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/1a93ef86-be5a-44ad-a814-14613fd0a78f) from my test environment with no luck, I've made sure the permissions to the Task Scheduler were correct (found a Google blip about that somewhere), I've deleted and re-installed the SSP multiple times, ran the Configuration Wizard more times than I can count, but no matter what I do it never changes and always gives the same error. Also, whenever I try to access Central Admin it tries redirecting me to http://servername:portnumber/_admin/SearchServerW

Access to Central Admin, but receive error when accessing sites

We have a dev environment where we've reattached the config database and content databases. We can get into Central Admin, but none of the other SharePoint sites. Here is the error I see in the event log, which I believe indicates the cause of the trouble (see below). Any ideas on how to resolve? Thanks! Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1310 Date:  9/17/2010 Time:  9:45:53 AM User:  N/A Computer: SVUSFULSPWEBTST Description: Event code: 3006 Event message: A parser error has occurred. Event time: 9/17/2010 9:45:53 AM Event time (UTC): 9/17/2010 4:45:53 PM Event ID: 2767d864409a4d8380e5cb38fa987b21 Event sequence: 3 Event occurrence: 1 Event detail code: 0   Application information:     Application domain: /LM/W3SVC/482174774/Root-1-129292155459206250     Trust level: WSS_Minimal     Application Virtual Path: /     Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\collabtest.beckman.com80\     Machine name: SVUSFULSPWEBTST   Process information:     Process ID: 2192     Process name: w3wp.exe     Account name: GLOBAL\svcSPAppPoolTst   Exception information:     Exception type: HttpParseExce

Error while accessing a WCF REST service from iphone


Hi All, I have a WCF Rest service which gets a image file as a byte array[]. It works fine if the client is .net. if the client is iphone[objective c] it says the following error. The incoming message has an unexpected message format 'Raw'. The expected message formats for the operation are 'Xml', 'Json'. This can be because a WebContentTypeMapper has not been configured on the binding. See the documentation of WebContentTypeMapper for more details. The service has been hosted secure site in iis.Please help me to resolve the issue. my method is

public string ImageData(byte[] imgfile) {

 long ll = imgfile.Length; byte[] dBytes = imgfile;

 Stream imgStream = new MemoryStream(dBytes, 0, dBytes.Length);

Bitmap bmpImage = new Bitmap(imgStream);

 bmpImage.Save(@"C:\1.jpeg", System.Drawing.Imaging.ImageFormat.Jpeg); return true; }

Error while accessing Web service



We have developed one webservice and it is deployed in our virtual directory. It is working fine.

But the problem is in otherhand. While they are accessing our Database through the web service this error is coming..


soap fault: Server was unable to process request. ---> Object reference not set to an instance of an object

Error in web service codes when accessing a list


Hi all

I've been getting error when i programatically try to access a list. below is my code from a web service:

public IDEASBase(SPWeb web)
      this._spWebPassedByParameter = true;
      this._web = web;
      SPList list = this._web.Lists[this._listName.ToString()];
      this._item = list.Items.Add();

According to the stack trace, the error occurs at SPList list = this._web.Lists[this._listName.ToString()];

Stack trace:

System.Threading.ThreadAbortException: Thread was being aborted.
  at System.Threading.Thread.AbortInternal()
  at System.Threading.Thread.Abort(Object stateInfo)
  at System.Web.HttpResponse.End()
  at Microsoft.SharePoint.Utilities.SPUtilityInternal.SendResponse(HttpResponse response, Int32 code, String strBody)
  at Microsoft.SharePoint.Utilities.SPUtilityInternal.Send401(HttpResponse response)
  at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(Exception ex)
  at Microsoft.SharePoint.SPGlobal.HandleUnauthorizedAccessException(UnauthorizedAccessException ex)
  at Microsoft.SharePoint.Library.SPRequest.GetListsWithCallback(String bstrUrl, Guid foreignWebId, String bstrListInternalName, Int32 dwBaseType, Int32 dwBaseTypeAlt, Int32 dwServerTemplate, UInt32 dwGetListFlags, UInt32 dwListFilterFlags, Boolean bPrefetchMetaData, Boolean bSecurityTrimmed, Boolean bG

>>Accessing higher date resulting error:



Putting date in textbox to search some particular record is working fine.

The problem occurs when I am trying to put higher date means today is 10/10/2010 and I am trying to get data for the date 10/13/2010.

I know it is not logical but to handle exceptions from user I am trying to do this but getting following error:

String was not recognized as a valid DateTime.

Any idea please be appreciated.

Getting HTTP 500 error while accessing sharepiont site with claims based authentication


I have configured one of my SharePoint sites default zone with windows authentication and claims authentication. I am able to access the site properly with windows authentication. But, when I am accessing the site with claims, I am getting Http 500 error. When I captured the http headers, I see below information.

Accept: image/jpeg, image/gif, image/pjpeg, application/x-ms-application, application/xaml+xml, application/x-ms-xbap, */*
Referer: https://myhost/adfs/ls/?wa=wsignin1.0&wtrealm=urn%3amyhost%3aadfsupn&wctx=https%3a%2f%2fmyhost.moss.com%3a9696%2f_layouts%2fAuthenticate.aspx%3fSource%3d%252F
Accept-Language: en-US
User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E; .NET CLR 3.5.30729; .NET CLR 3.0.30729)
Content-Type: application/x-www-form-urlencoded
Accept-Encoding: gzip, deflate
Host: myhost.moss.com:9696
Content-Length: 5676
Connection: Keep-Alive
Cache-Control: no-cache
Cookie: SPSessionGuid=d2cc8d44-e1a0-4412-9a9e-59a461c57eab


Error while accessing web service


I have tested the example showed on MSDN for accessing a SharePoint List Web Service in http://msdn.microsoft.com/en-us/library/ms772599(v=office.12).aspx

Build is OK. However, I get the following error while running try block.

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

Any ideas?

Accessing response of HttpWebRequest, even when request returns 500 Internal Server Error



Hoping someone can point me to a solution, haven't been able to find one yet.

I'm using the standard way for send HttpWebRequest

		webRequest = (HttpWebRequest)WebRequest.Create(request.URL);
webRequest.Method = "POST";
webRequest.ContentType = "text/xml";


postStream = webRequest.GetRequestStream();
postStream.Write(requestBuffer, 0, requestBuffer.Length);
webResponse = (HttpWebResponse)webRequest.GetResponse();
responseStream = webResponse.GetResponseStream();
responseReader = new StreamReader(responseStream);
string response = responseReader.ReadToEnd();

This is all fine, working correctly, no poblems.

However the actual webservice that i'm calling returns a 500 Internal Server Error code for standard faults

HTTP/1.1 500 Internal Server Error
Content-Type: text/xml; charset=utf-8
Content-Length: 703
Date: Fri, 22 Oct 2010 04:50:48 GMT

<?xml version="1.0" en
coding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.o

Error while accessing the Sharepoint Foundation http://sharepoint server:port/_vti_bin/lists.asmx



Error while accessing the Sharepoint Foundation http://sharepoint server:port/_vti_bin/lists.asmx. we got below error. please help us to sort this below error.

The top XML element 'string' from namespace 'http://schemas.microsoft.com/sharepoint/soap/' references distinct types Microsoft.SharePoint.SoapServer.SoapXml.SoapXmlElement and System.String. Use XML attributes to specify another XML name or namespace for the element or types.


Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: fe7f8707-44db-4744-8a78-337a5e8a80de

Date and Time: 10/25/2010 10:32:28 AM

Thanks & Regards,



getting error while accessing sharepoint usergroup webservice.



here is my code

ServiceReference1.UserGroup usrgrpService = new ServiceReference1.UserGroup();
            usrgrpService.Credentials = System.Net.CredentialCache.DefaultCredentials;
            usrgrpService.Url =

            XmlNode usersSite = usrgrpService.GetUserCollectionFromWeb();         


the UserGroup class is not getting populated in the intellisense and when i compile the progam i am getting the following error. the type or namespace 'Usergroup' does not exists.

my aim is to get the usergroups of a subsite in to sql database using sharepoint object model and sharepoint webservices. can any one please guide me how to proceed.

When accessing SharePoint or Central Administration 3.0 a "503 Service Unavailable" error is returne

I am running a MOSS 2007 server in a test environment. I have been off building other aspects of the environment, but I come back today and notice that SharePoint is no longer working. Whenver I try to access it or the Central Administration area I recieve a "503: Service Unavailable" error.

I have also notice that after an IISRESET that the applications pools that are associated with the SharePoint sites (Extranet, Intranet, Sharepoint - 21075, and Central Administration fail to start on their own. I can start the manually. They are all running under the DOMAIN\Administrator account (as are ALL of the SharePoint related features. I know, I know, but that is what the requestor of this test environment requested).

Additionally the following error codes are logged (NOTE: These are translated from German):

Event ID: 6641
Source: Office Sharepoint Server
The SSP timer Mandate for import distribution lists did not execute.

Reason: Registration failed: The user does not have the required logon on this computer.

Event ID: 2424
Source: Office Server Search
The update cannot be started because there is no access to

7399 error for accessing Pervasive db


Dear all,

I am having a 7399 error and cannot solve, can anyone please indicate how might be probably solve the problem:

Server: Windows server 2008 (32 bit)
Sql Server: Sql server 2008 R2 (32 bit)
Linked Server DB: Pervasive 10.0
Linked Method: Pervasive OLEDB Linked to Z:\ (z drive contains pervasive data file)
Error Message 7399
Others: SQL Server 2008 R2 is using Windows Authenication method to log in.  Windows can access the Z:\ path with another username and password

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Program Location:

   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.RunQuery()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Process()
   at Microsoft.SqlServer.Management.UI.VSIntegrati

Designer Error when accessing files: Server could not complete your request


on our development server, I suddenly cannot access files through Designer.  The site opens, but when I try to open the list folder to get to the files, I get:

The server could not complete your request.  Contact your Interner service provider or webserver administrator to make sure that the server has the FP Server Extensions or SP Services installed.

The weird thing is that I can log on to Designer from another computer and it works fine. Clicking on the Details button reveals nothing.  Our server admin is just learning.  Can anyone recommend any ideas?

There are no mistakes; every result tells you something of value about what your are trying to accomplish.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend