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

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

FullTextQuery not working after upgrade to SharePoint 2010

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :SharePoint
I have a function   Public Function QueryEx(ByVal webUrl As String, ByVal queryXml As String) As DataSet     Dim ds As DataSet = Nothing   Try   Dim myCredentials As NetworkCredential = CredentialCache.DefaultNetworkCredentials sws =   New SearchService.QueryService sws.Url = webUrl &   "/" & webServiceName   CType(sws, SearchService.QueryService).QueryEx(queryXml)     Catch ex As Exception lblDebug.Text =   "QueryEx: " & ex.Message pnlError.Visible =   True ds = Nothing   Finally sws.Dispose()   End Try   Return ds     End Function and passed the following full text query wrapped in the appropriate xml SELECT FileExtension, Filename, EffectiveDate, Title, Author, State, PolicyType, ApplicationType, PolicyNumber, ClientCode, CreatedBy, Created, ModifiedBy, LastModifiedTime, Path FROM portal..scope() WHERE ("SCOPE" = 'MyDeptScope') AND "IsDocument" = 1  AND ("Filename" LIKE 'Sub%') this worked in SharePoint 2007. We upgraded to SharePoint 2010.  I have all the managed properties setup the same on both versions.  I had to modify the query to get past one error I was receiving to SELECT FileExtension, Filename, EffectiveDate, Title, Author, State, PolicyType, ApplicationType, Pol

View Complete Post

More Related Resource Links

ReportViewer webpart is not working after SharePoint 2010 upgrade


After upgrading to SharePoint 2010 and Reporting Services 2008 (separate servers), all our web part pages that have the ReportViewer web parts in them are not working.  The error we are getting is "Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe."  All the reports are working on the report server but not through the web parts.  We used Visual Studio 2005 to create these reports and they all work in MOSS 2007 that also ran Reporting Services 2005.  If we delete the web part with the error and put in the ReportViewer web part manually on the page in SharePoint 2010, the reports do work.  But there are too many reports to be doing this manually for every web part page.  We already tried making changes to the Handler Mappings but it did not resolve the errors.  As far as we can tell, all the DLLs are in the right places.  Any help or suggestions would be greatly appreciated.  Thanks.

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


How to upgrade from Windows SharePoint Services 2.0 to SharePoint Foundation 2010 after mistanely de


I need a detailed instruction on how to upgrade From Upgrading from Windows SharePoint Services 2.0  (SBS 2003 ) to SharePoint Foundation 2010.

Background of the case:

I have all my databases (STS-database and STS_Config) saved but, I forgot to save my Virtual Site )Companyweb site) and I mistakenly re-installed IIS on the SBS 2003, hence  I lost the companyweb site. Is this an issue to migrate to Sharepoint foundation 2010. The Sharepoint foundation 2010 is running on a Microsoft HyperV Server 2008 R2
Also, I have created a Virtual 2003 SRV ENT with Sharepoint Services 3.0 running on it. I also have attached my Databases STS_Database and STS_Config)... how do I get it working like a regular website. I have modified the CNAME record to reflect the new server... http://companyweb - it take me to the new site but it loads a blank page. I did create a new CompanyWeb Virtual site on the VHD 2003 server.
Your help is greatly appreciated.

Thanks for your prompt response. Nelson

SharePoint 2010: Upgrade Resource Center (Developers)

Are you ready to move to SharePoint 2010? Learn about upgrading customizations and reusing your code.

Quick Note: Working with the SharePoint 2010 Ribbon User Interface

Learn to extend the Microsoft SharePoint 2010 ribbon by adding a custom button that executes server-side code.

Preparing for SharePoint 2010 Upgrade Today

The SharePoint product team has provided guidance on a number of items that can help organizations prepare, and Service Pack 2 includes a key tool that can provide additional insight and configuration information. This paper, by Quest SharePoint senior architect and evangelist Joel Oleson, walks you through using this key tool and offers major items to consider as you prepare for a SharePoint 2010 upgrade.

HTTP Error 500.19 - Internal Server Error after SharePoint 2010 In-place upgrade

Hello We have done an SharePoint 2010 In-Place Upgrade. After the upgrade, we can access the Central Administration page without problems. However, when accessing the standard http port 80 site, the following error appears: Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.   <fieldset><legend>Detailed Error Information</legend> Module IIS Web Core Notification Unknown Handler Not yet determined Error Code 0x80070032 Config Error The configuration section 'system.web.extensions' cannot be read because it is missing a section declaration Config File \\?\C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config Requested URL http://coolsharepoint:80/ Physical Path   Logon Method Not yet determined Logon User Not yet determined </fieldset> <fieldset><legend>Config Source</legend> 534: </location> 535: <system.web.extensions> 536: <scripting> </fieldset>

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

When Upgraded a site from Wss 3.0 to Sharepoint foundation 2010, subsites are not working

HI ALL, I recently migrated an old Sharepoint site from WSS 3.0 to Sharepoint foundation 2010. There were no problems during the upgrade and the stsadm command displayed the message that upgrade completed successfully. However when I am accessing the sub-sites from outside the server, I am able to see the content, but when I go to Site Settings, I get an error "File not found". Also the Views for the sub-sites are not working. However on accessing the sub-sites from the Server everything is working fine. Can anyone please help me?  

Meeting Workspace unusable after SharePoint upgrade to 2010

Hello, We recently took a content database from MOSS 2007 and attached it to a SharePoint 2010 farm that uses a different DNS name. Now, there's a user who had a recurring meeting configured in Outlook 2010 with a meeting workspace  who can no longer use the workspace now that it only exists on SharePoint 2010. She tried removing the link to the old workspace from her recurring meeting and adding a new location using the new URL, but she gets a message saying a workspace already exists at the site. Obviously it does, but the meeting in Outlook is the same meeting. Is there any way to re-connect the Outlook meeting with the meeting workspace that exists on the new SharePoint 2010 server? Thanks.

SharePoint 2010 in place upgrade "Cannot complete the action"

I currently did an inplace upgrade to SharePoint 2010 Standard in a medium farm deployment with one WFE and a remote SQL server with one site collection.  The upgrade process was marked as finished in CA.  The problem now is with the root site in the site collection is throwing the error "Cannot complete the action".  I've narrowed it down to the "Pages" library in the the root site.  The root site is using site template id = 20 template name = SPS#0, and template title = SharePoint Portal Server Site.  If I hard code the URL in IE address bar I can get everywhere on the root site including the settings page of the "Pages" library.  The error is thrown when I try to access the "Manage Permissions" link of the "Pages" library or when I try to browse to http://<rootsite>/pages/default.aspx. I believe the default.aspx page was customized by the customer when they were on SharePoint 2007 Standard.

SharePoint 2010 - "My Inbox"(OWA) webpart not working with Exchange 2010

Hi, I'm trying to setup the webpart "My Inbox" (OWA) in SharePoint 2010. It works when connecting to OWA running exchange 2007, but failes with error 400 not found when connecting to OWA running Exchange 2010. The error appears after logging in.  I'm using this url: https://<exchangeserver>/owa I assume that this should be supported by Exchange 2010, but it seems to fail using this parameter /?cmd=contents. Any suggestions?   Best regards, Petter

sharepoint 2010 content rating not working

Hi, I can't get my content rating to work.  I can give something a rating, and when I go back, there is nothing there.  I know about the timer service, and have wated (over a week) and also ran the timer service using the stsadm command and nothing seems to work.nonam

Incomming Email Not Working Correctly in SharePoint 2010

Hello everyone, We recently upgraded from SharePoint 2007 to 2010. Prior to the upgrade I had two SharePoint Document libraries setup to receive incoming emails. We had two reports scheduled in Reporting Services and each report emailed a document library once a week. After the upgrade this stopped working. The reason this stopped working was because the file names of the attachments were the same each week, however in 2007, sharepoint would append a random 4 digits to the end of the file name. Was the removed from 2010 on purpose? After discovering this didn't work, I decided to create a workflow on these lists that anytime and item is added go change the file name to include the list ID to ensure that the file names will be unique. Only to find out that items added to the list from the incomming emails do not trigger the workflow. Doing some research on this and it looks like it was turned into Mircosoft as a bug in 2007 which had a fix, but the fix is only for 2007 is doesn't say it applies to SharePoint 2010 so I don't want to install it. Anyone know if there is a fix for this in SharePoint 2010? Thanks in advance, Matt

Access Denied/The workflow could not copy the item workflow error after Sharepoint 2010 upgrade

We have a sharepoint designer workflow that copies a document from one library to another on the same site.  Before the upgrade to 2007 it worked fine, but now with 2010 it gives an error and cancels the workflow when it gets to the copy list item step.   The error on the workflow page: The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.  Access Denied   Specifically it is the "copy list item current item to documentlibrary" sharepoint designer workflow action.   I have given the system account full permissions to the library and double checked that all columns are the same in both libraries. These are the verbose trace logs:   09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72er Medium System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied. at Microsoft.SharePoint.SPFile.UpdateInternal(Boolean migrationSemantics, Boolean reGhost) at Microsoft.SharePoint.Workflow.SPWinOEWSSService.CommitCopyFile(Transaction txn, Object[] transData) 09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72fe High Error in commiting pending workflow batch items: Sys

Copy List not Working in Sharepoint 2010 Designer Workflow

I am having two custom lists,  First_List(Title, ID, Status) and Second_List(Title, ID) here Status is a choice menu with values Selected and Rejected I am copying data from First_List to Second_List using WorkFlow with SharePoint Designer, When I am inserting data in first list. For that I have written in workflow action if CurrentIten. Status equals Selected  Copy item in current item to Second List now the Problem is that only the Title field is getting copied into the Second List but I am unable to copy the ID field. I am unable to understand whats the problem    

SharePoint 2010 Claims Based Authenticaton site working but search is broken

Hi, I have SP 2010 sucessfully installed on a Windows 2008 R2 server with SQL Server 2008 R2.  I created local machine accounts for the following: MACHINE\mssqlservice MACHINE\sp_admin MACHINE\sp_search MACHINE\sp_farms I have setup 2 sites with public facing internet access as well as local sites. I have CBA working properly on both sites from both public and private access. My problem is that when I go to search, I am constantly redirected to an error page. I have checked all SP services on the server and they are all running as MACHINE\mssqlservice That account has proper access to all sites as well as all DB's. My search is crawling and I get one error from a long named PDF file in my site, which is OK.   My questions is if my CBA is working fine and my search is crawling, why I am not getting a results page when I search from the sites:   Here is the error I get:   Error Internal server error exception:   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 5a03b730-42c2-48c9-a220-3b9d052481de Date and Time: 9/9/2010 4:45:07 PM   I am kind of stuck at this point and am not sure how to proceed.  Any help would be appreciated.        --TR
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