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

Top 5 Contributors of the Month
david stephan
Post New Web Links

Contenttype and contentsource unavailable in FullTextSqlQuery

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

In my 2007 enviroment I was able to build a query like 'SELECT Title, Path, ContentType, ContentSource FROM....'

But I deployed my custom code to a SP2010 environment, updated the obsolete code.

In the 2010 environment I'm unable to use ContentType or ContentSource as select fields...

All my other customer meta data mappings do work.

var proxy = (SearchServiceApplicationProxy)SearchServiceApplicationProxy.GetProxy(SPServiceContext.GetContext(SPContext.Current.Site));
        qry = new FullTextSqlQuery(proxy)
               TrimDuplicates = true,
               EnableStemming = false,
               IgnoreAllNoiseQuery = true,
               ResultTypes = ResultType.RelevantResults,
               QueryText = sql,
               RowLimit = 100

        ResultTableCollection results;
var sb = new StringBuilder();
      sb.Append("SELECT Rank,Title,Path,HitHighlightedSummary,VMMaContentType,");

View Complete Post

More Related Resource Links

Sharepoint site shows Service Unavailable


Hello everyon,

I am working sith WSS 3.0.

I have one webapplication with one sitecollection.Later i wanted to provide it HTTPS URL, so i extended the WebApplication with option-Yes in SSl field.

And in the virtlay directory properties -> Directory Security -> Secure communications -> Edit

selected Required Secure Chanel.

Thats it. I didn't do anything in that.


Then because of some problems , i deleted the iis website of extended webapplication from central admin.

After that when ever i try to open the site, it shows service unavailable.  And the application pool is getting disabled.

Please help me to get the site working.


Thanks in advance.


Remote Connection Unavailable

Hello, I am attempting to attach to my new Windows 2008 R2 SQL Server 2005 standard clustered remotely.  The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip.  I have attempted to check the browser configuration but I can't find this. I can attach to the sql server on my cluster but am unable to on a remote machine error is: Cannot connect to clustered name\instance name Addtional info A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is configured to allow remote connections. Ideas? Thx -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

Error calling WCF service that is returning list.".Debugging resource strings are unavailable ......

Ok.this is just making me frustrated... Here is step by step of what I am trying to do (& not able to) 1. I am calling WCF service hosted in a SharePoint 2010 site from a silverlight app in same domain (So no cross doman I guess). 2. I use Linq to Sharepoint for querying the DB. 3. I am having a list "machines" in Sharepoint 2010 that is having a lookup column from Other list called "part" 4. My WCF method GetAllMachines() works perfectly well when it skips the lookup column "partname" & returns List of type machineitem. 5. But problem occurs when I add machineitemobject.parts.partsname in my Linq to Sharepoint query . My service gives the error not found Async_ExceptionOccurred] Arguments: Debugging resource strings are unavailable." 6. Note that return type of my Method is List<machinesitem> 7. The point to note here is that I use SPMETAL tool to generate the LINQ class that maps the lists . So When I try to query the lookup column it tries to add List item of the type class & that is what causing the error. Is it because I am not using datacontract in my service (but it returns the strings & all private members of machines list e.g. name,title etc) Is it making the attribute Serialisable will solve the error ??? I am kind of lost in it ...Plss help!!   Thanks

The remote server returned an error: (550) File unavailable (e.g., file not found, no access).

Hi.   I have read the other threads regarding this but they do not solve my problem. All i am trying to do is upload a file from the webserver onto another server via FTP. But i get the above error and am at my wits end as to why.   below is the code:   Dim fs As New FileStream("H:\Visual Studio 2005\Websites\Website1\testfile.txt", FileMode.Open) Dim filecontents(fs.Length) As Byte fs.Read(filecontents, 0, fs.Length)   Dim remotePath As String = "ftp://elonwactd.uk.ml.com/apps/files/IPBHVGTRADE/QA5/in/testfile.txt" Dim ftp As FtpWebRequest = FtpWebRequest.Create(remotePath) ftp.Credentials = New System.Net.NetworkCredential("user1", "passwd1") ftp.KeepAlive = False ftp.UseBinary = True   ' (have tried UploadFile as well instead of UploadFileWithUniqueName) ftp.Method = WebRequestMethods.Ftp.UploadFileWithUniqueName     fs.Close()   ftp.GetRequestStream.Write(filecontents, 0, filecontents.Length) ftp.GetRequestStream.Close() ftp.GetResponse.Close()     Below is the stack trace that i get. [WebException: The remote server returned an error: (550) File unavailable (e.g., file not found, no access).]   System.Net.FtpWebRequest.SyncRequestCallback(Object obj) +321   System.Net.FtpWebRequest.RequestCallback(Object obj) +19   System.Net.CommandStream.Abort(Exception e) +163   System.Net.FtpWebRequest.FinishRequestStage(RequestStage stage) +45

I am getting System.Web.Services.Protocols.SoapHeaderException: Server unavailable error?..

 Hi,    I am using WSE 3.0 for my applicaton. when run from the client end I am getting following error.System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.ApplicationException: WSE841: An error occured processing an outgoing fault response. ---> System.Web.Services.Protocols.SoapHeaderException: Microsoft.Web.Services3.Security.SecurityFault: Header http://schemas.xmlsoap.org/ws/2004/08/addressing:Action for ultimate recipient is required but not present in the message.  at Microsoft.Web.Services3.Design.RequireSoapHeaderAssertion.RequireSoapHeaderFilter.ProcessMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.Pipeline.ProcessInputMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.WseProtocol.FilterRequest(SoapEnvelope requestEnvelope)  at Microsoft.Web.Services3.WseProtocol.RouteRequest(SoapServerMessage message)  at System.Web.Services.Protocols.SoapServerProtocol.Initialize()  at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)  --- End of inner exception stack trace ---  --- End of inner exception stack trace ---         Help needed on this. re

SPSiteDataQuery not working for ContentType

Could someone help me figure out why this is not working?  I am trying to use a SPSiteDataQuery object to return all documents in all document libraries in a site collection, excluding folders.  The query works fine in U2U Caml Query Builder but when i run it using the SPSiteDataQuery class it is returning folders and documents.  Sometimes it crashes on the GetSiteData call, but that seems to be another problem related to the MFP_Group column, which is a managed metadata site column.  Here is my code: Using web As SPWeb = OpenWeb(sSite) Dim oQuery As New SPSiteDataQuery oQuery.Lists = "<Lists ServerTemplate='101' />" oQuery.ViewFields = "<FieldRef Name='Title' />" & _ "<FieldRef Name='Project_x0020_Number' Nullable='TRUE' Type='Text'/>" & _ "<FieldRef Name='ContentType'/>" & _ "<FieldRef Name='Project_x0020_Status' Nullable='TRUE'/>" & _ "<FieldRef Name='FileRef' Nullable='TRUE'/>" & _ "<FieldRef Name='Pegasys_x0020_Ref_x0020_Number' Nullable='TRUE'/>" & _ "<FieldRef Name='MFP_x0020_Group' Nullable='TRUE'/>"  oQuery.Query = "<Where><Neq><FieldRef Name='ContentType'/><Value Type='Text'>Folder</Value><

Web Front End does not work - service unavailable

Greetings I had problem with installing reporting services integrated with moss 2007, i somehow installed moss 2007 (web front end for the pc which will have RS instaled) without IIS, then IIS wouldnt install at all, and i decided to start over: So, i have two PC's (a PC and a virtual, to be percise). CONDORPC Has the Office Sharepoint 2007 installed and running (main server). Has SQL for the sharepoint and everything. MOSS2K7 Is the new clean install of 2008 server.   What i have installed and done to 2008 server: - Installed IIS. At first it didnt install because it had numerous problems (error log was infested with something like "could not change state of package XXX to installed state"). It asked to reboot to rollback. After reboot at second install attempt it installed correctly. - Turned off default IIS website - Installed SQL database engine as in this tutorial (http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html#Step-4:-Installation-of-SharePoint-2007-on-SSRS2008SPIM) This SQL will house my reporting services databases. The service is ran by network service local account. - Installed SQL RS as in the tutorial. Didnt configure it yet. It is running as domain account. - Installed .NET framework required by moss (funny how it tried to access the internet to download something athough it was a complete full download for standal

RPC Unavailable error when configuring SPF2010 on DMZ

I'm having trouble configuring SharePoint Foundation 2010 in a DMZ environment.  My SharePoint web and application server is on the DMZ, along with an Active Directory Read-Only Domain Controller.  My target database server is on the internal network, as is the AD domain control referenced by the RODC. When running the SharePoint Configuration Wizard, I answer all of the questions and it starts chugging along, creating an admin database, but the progress bar never advances past "task 3 of 10" before failing with the error: "An exception of type System.InvalidOperationException was thrown.  Additional exception information: An error occurred while getting information about the user netportal at server mydomain.net: The RPC server is unavailable" The RPC service is running on the web server, database server, and RODC. Is there some sort of temporary opening of AD access that needs to occur in order for SharePoint to successfully configure?  Should I configure the web/application server inside the corporate network, then move it to the DMZ afterwards? I'm thinking that SharePoint is having a problem with the RODC, but I'm not sure what. Has anyone else run into a situation like this?

BDC suddenly becomes unavailable

Hi there I have a problem with my BDC in SharePoint Foundation suddenly does not work anymore. The only way I got my BDC to run again was to reboot the server but it's not tenable to have to restart it when the error occurs (sometimes there have been 14 days between the error occurred). In Event Viewer I get the following two error messages: First error message   - Provider    [ Name]  Microsoft-SharePoint Products-SharePoint Foundation    [ Guid]  {6FB7E0CD-52E7-47DD-997A-241563931FC2}    EventID 8306    Version 14    Level 2    Task 47    Opcode 0    Keywords 0x4000000000000000   - TimeCreated    [ SystemTime]  2010-08-27T09:50:28.958609600Z    EventRecordID 2415   - Correlation    [ ActivityID]  {4A69B4E8-10BE-4AB3-BEE5-2418C9CAA973}   - Execution    [ ProcessID]  3428    [ ThreadID]  1136    Channel Application    Computer SHAREPOINTSRV.xxx.com   - Security    [ UserID]  S-1-5-21-1606980848-329068152-839522115-500 - EventData   string0 The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute o

New to XAML, need a bit of help: Settings Tooltip of ContentSource?

<ContentPresenter x:Name="ContentSite" ToolTip="" ContentSource="Header" RecognizesAccessKey="True" HorizontalAlignment="Center" Margin="3,0,3,0"/> I wish to set the tooltip as what the contentsource is. This is under my tabitem which is under the tabcontrol.GINtech Systems Owner

Problem when deployind ContentType: Error occurred in deployment step 'Activate Features': Field t

Im getting this error when i try to Deploy my ContenType: Error occurred in deployment step 'Activate Features': Field type GUID is not installed properly. Go to the list settings page to delete this field Does someone know how to fix this error? The ContentType is defined as: <     Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <!--Site columns--> <Field Name="Test" DisplayName="Customer Subject ID" ID="{38A9E5BA-62FF-4F3B-90E3-F9961FEABE20}" Type="Text" Required="FALSE" /> <!--Parent ContentType: Item (0x01) --> <ContentType ID="0x01004317ec735b25468583d7470aa17c36ae" Name="NextContentTypes - NextCustomerContentType" Group="Next Content     Types"Description="NextCustomerContentType" Inherits="TRUE" Version="0"> <FieldRefs> <!-- References to field difinitions --> <FieldRef ID="{38A9E5BA-62FF-4F3B-90E3-F9961FEABE20}" Name="Test"></FieldRef> </FieldRefs> </ContentType> </     Elements>

FullTextSqlQuery unexpected result ( Sharepoint 2010 Foundation )

Hello All,I am trying write webpart related with search functionality in sharepoint and FullTextSqlQuery returns unexprected result. I couldn't understand why. In following code I am expecting results for default sharepoint ( sharepoint:80 ) website but it returns cental administration site search results.DataTable resultDataTable = new DataTable();FullTextSqlQuery FTQ = new FullTextSqlQuery(SPContext.Current.Site);FTQ.ResultTypes = ResultType.RelevantResults;FTQ.QueryText = "SELECT FileExtension, ContentClass, IsDocument, rank, title, path, author from scope() ";     ResultTableCollection resultTableCollection = FTQ.Execute();ResultTable resultTable = resultTableCollection[ResultType.RelevantResults];resultDataTable.Load(resultTable);In resultDataTable (path column) all rows related with Centeral Administration site. So, do you have any idea why?PS: I have tried following way to make sure it is runing on default web site;insted of "new FullTextSqlQuery(SPContext.Current.Site);", I put "new FullTextSqlQuery(new SPSite(http://sharepoint:80));" but result is same.  

How to solve this "Smtp: Mailbox Unavailable or not local " error ?

I am trying to send Email to the Email Addresses stored in the Database, some are working fine but I am getting stuck when I get hit with this error.. The server rejected one or more recipient addresses. The server response was: 550 Requested action not taken: mailbox unavailable or not local I think this is something to do with SMTP Virtual Server Settings in IIS but i dont know what actually i should change over there. The code in the ASP.NET page worked for 40-50 mail addresses but suddenly i am getting this error Can anyone help please. Any ideas will be of great help to me .. Thanks in Advance

Send Email Failed.Mailbox unavailable.

Hi I am trying to do send a mail from asp.net to skype/ gmail. i have some clarification smtpClinet.Host == Means what, what value i can assign here. //localhost smptClient.Port == Means what, what value i can assign here. // 25 I give localhost as host name, 25 as port what are the name space i want to add. any thing  to be add in web.config... when i send,below mentioned error appear. Please anyone help me... Send Email Failed.Mailbox unavailable. The server response was: 5.7.1 Unable to relay for andrews198022@skype.com   

How to search documents from the particular document library using FullTextSqlQuery in sharepoint?

Hi, I want search (wildcard search) the document from the particular document library using FullTextSqlQuery class. Thanks Srikanth Reddy

Deploy Error on contentType.UpdateWorkflowAssociation(wfAssociation);

I am using vs.net 2010 and deploying my feature which includes a workflow. I am getting the following error "Error 5 Error occurred in deployment step 'Activate Features': There is already a workflow association with this name 'Test Level'" This error is occurring on the following line contentType.UpdateWorkflowAssociation(wfAssociation);  If I remove the attempt to update the workflow association it deploys ok.  Also, if i remove the deployment site and recreate it so that there isn't a workflow association it works ok as well. Why am I getting this error on contentType.UpdateWorkflowAssociation(wfAssociation) ??   thanksdave

"BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object i

After installing SharePoint 2010 Beta and Sharepoint Designer 2010, opening Designer and navigating to the External Content Types object results in the following error:"The Business Data Connectivity Metadata Store is currently unavailable."Anyone else having this experience?ThanksMark
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