Problem with French site after creating Variation

I had a problem with a French variation that I created from an English publishing site. The site looked like it was missing some CSS files. After some investigation it was found that some theme files in the "_catalogs/theme/Themed/94CF7155/" folder were missing and returning 404 to the browser. After trying to reapply the theme, that did not work. I reset the theme to something else, then reset it back to our default. That resolved the issue.

Errors That Annoy Me

These sort of errors always annoy me:


Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 12/5/2011 12:00:07 AM
Event ID: 5586
Task Category: Database
Level: Error
Keywords:
User: SERVICES\svc.sp.farm
Computer: SHAREPOINT.services.local
Description:

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure 'proc_UpdateStatisticsNVP'.


Now if only there was a fix.

http://support.microsoft.com/kb/2635071

SharePoint Search Returns No Results

Recently I had a problem where no results were being returned when performing a search in a SharePoint site. I checked the crawl log and sure enough the results were being crawled. The site collection was in a web application that was using Windows authentication, I had another web application on the farm that was using Claims authentication and the search results were working as expected. The SharePoint servers are in a service domain seperate than the corporate domain, and there is a one way trust to the corporate domain from the service domain.

After some investigation, the following was found in the SharePoint logs:


12/02/2011 13:26:29.59 w3wp.exe (0x39CC) 0x1B34 SharePoint Server Search Query Processor g2j3 High AuthzInitializeContextFromSid failed with ERROR_ACCESS_DENIED. This error indicates that the account under which this process is executing may not have read access to the tokenGroupsGlobalAndUniversal attribute on the querying user's Active Directory object. Query results which require non-Claims Windows authorization will not be returned to this querying user. 06652a9d-db8c-462d-a845-9ef1dad6aa0c


After some additional investigation, the problem appeared to be the search service application account does not have rights to read the active directory account of the user performing the search. Doing some additional searches eventually turned up the following Microsoft KB article:

http://support.microsoft.com/kb/2344518

The following resolution in the arcticle resolved the issue for me:


$searchapp = Get-SPEnterpriseSearchServiceApplication
$searchapp.SetProperty("ForceClaimACLs",1)


InfoPath People Picker Issue with SharePoint 2010 when using F5 BigIP

We had an issue recently after implementing a F5 BigIP load balancer/SSL accelerator, the people picker in all InfoPath forms published to SharePoint stopped working. After some investigation, it was found that the claim provider web service was expecting InfoPath to use a different URL than it was actually using. InfoPath was requesting from spclaimproviderwebservice.https.svc, however since the SSL acceleration was done externally SharePoint was expecting InfoPath to use spclaimproviderwebservice.svc. We resolved the problem by creating the following irule on the F5 BigIP:


when HTTP_REQUEST {
if { [[string tolower] [HTTP::path]] contains "spclaimproviderwebservice.https.svc"} {
HTTP::path [string map {.https ""} [HTTP::path]]
}
}


CQWP and Manage Content and Structure Errors in SharePoint 2010

I recently moved a SharePoint 2010 site from one environment to another, after moving the site it was found that the owners were unable to open the Manage Content and Structure link and were unable to open the Lists in the CQWP. After some investigation, the following errors were listed in the logs:


11/23/2011 11:27:45.67 w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (GET:https://sharepoint/_layouts/sitemanager.aspx?Source=%2Fsites%2FARD%2FStyle%2520Library%2FForms%2FAllItems%2Easpx%3FRootFolder%3D%252Fsites%252FARD%252FStyle%2520Library%252FXSL%2520Style%2520Sheets%26FolderCTID%3D0x0120006D0582336C3C1A45BC73F2AB7D0FB1C9%26View%3D%257B08D4A066%2DDF0E%2D45CB%2D8814%2D9B1D5AAFD73D%257D%26InitialTabId%3DRibbon%252EDocument%26VisibilityContext%3DWSSTabPersistence%26))
11/23/2011 11:27:45.67 w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://sharepoint/_layouts/sitemanager.aspx?Source=%2Fsites%2FARD%2FStyle%2520Library%2FForms%2FAllItems%2Easpx%3FRootFolder%3D%252Fsites%252FARD%252FStyle%2520Library%252FXSL%2520Style%2520Sheets%26FolderCTID%3D0x0120006D0582336C3C1A45BC73F2AB7D0FB1C9%26View%3D%257B08D4A066%2DDF0E%2D45CB%2D8814%2D9B1D5AAFD73D%257D%26InitialTabId%3DRibbon%252EDocument%26VisibilityContext%3DWSSTabPersistence%26) e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.67 w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/sites/ARD e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77 w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Runtime tkau Unexpected System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SharePoint.Publishing.Internal.WebControls.ObjectSerializer.DeleteAllowed(Boolean checkPermissions) at Microsoft.SharePoint.Publishing.Internal.WebControls.SmtButtonField.FormatDataValue(Object dataTextValue, Boolean encode) at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender, EventArgs e) at Microsoft.SharePoint.Publishing.Internal.WebControls.SmtButtonField.OnDataBindField(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebCon... e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77* w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Runtime tkau Unexpected ...trols.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at Microsoft.SharePoint.WebControls.SPGridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSele... e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77* w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Runtime tkau Unexpected ...ct() at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() at System.Web.UI.WebControls.GridView.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77 w3wp.exe (0x1E14) 0x1380 SharePoint Foundation General 90hv Unexpected Detected use of SPRequest for previously closed SPWeb object. Please close SPWeb objects when you are done with all objects obtained from them, but not before. Stack trace: at Microsoft.SharePoint.SPWeb.get_AlternateUILcids() at Microsoft.SharePoint.Utilities.ThemingLocations.AddWebLanguagesToCollection(SPWeb web, HashSet`1 langCollection) at Microsoft.SharePoint.Utilities.ThemingLocations.GetFilteredLanguagesForWeb(SPWeb web, Boolean bAllLangsInSPSite) at Microsoft.SharePoint.Utilities.ThemingLocations.GetThemableStylesFolders(SPWeb web, Boolean includeFileSystem, Boolean bAllLangsInSPSite) at Microsoft.SharePoint.WebControls.CssRegistrationRecord.UpdateThemableReferences(SPWeb web, IEnumerable`1 references) at Microsoft.SharePoint.WebControls.CssLink.Render(HtmlT... e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77* w3wp.exe (0x1E14) 0x1380 SharePoint Foundation General 90hv Unexpected ...extWriter output) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlHead.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boo... e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77* w3wp.exe (0x1E14) 0x1380 SharePoint Foundation General 90hv Unexpected ...lean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP._layouts_error_aspx.ProcessRequest(HttpContext context) at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) at System.Web.HttpServerUtility.Execute(String path, TextWriter writer, Boolean preserveForm) at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at System.Web.HttpServerUtility.Transfer(String pat... e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77* w3wp.exe (0x1E14) 0x1380 SharePoint Foundation General 90hv Unexpected ...h) at Microsoft.SharePoint.Utilities.SPUtility.TransferToErrorPage(String message, String linkText, String linkUrl) at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.ErrorHandler(HttpApplication app, Boolean errorIsOnErrorPage) at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.ErrorAppHandler(Object oSender, EventArgs ea) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.HttpApplication.RaiseOnError() at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntim... e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77* w3wp.exe (0x1E14) 0x1380 SharePoint Foundation General 90hv Unexpected ...e.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) e4319917-324c-4a18-80df-a48c392d684c
11/23/2011 11:27:45.77 w3wp.exe (0x1E14) 0x1380 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://sharepoint/_layouts/sitemanager.aspx?Source=%2Fsites%2FARD%2FStyle%2520Library%2FForms%2FAllItems%2Easpx%3FRootFolder%3D%252Fsites%252FARD%252FStyle%2520Library%252FXSL%2520Style%2520Sheets%26FolderCTID%3D0x0120006D0582336C3C1A45BC73F2AB7D0FB1C9%26View%3D%257B08D4A066%2DDF0E%2D45CB%2D8814%2D9B1D5AAFD73D%257D%26InitialTabId%3DRibbon%252EDocument%26VisibilityContext%3DWSSTabPersistence%26)). Execution Time=101.525324336197 e4319917-324c-4a18-80df-a48c392d684c

11/23/2011 09:54:00.62 w3wp.exe (0x2360) 0x160C SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (GET:https://sharepoint/_layouts/PickerTreeView.aspx?title=CbqPickerSelectListTitle&text=CbqPickerSelectListText&filter=websLists&root=&selection=&featureId=&errorString=&iconUrl=/_layouts/images/smt_icon.gif&scopeToWeb=&requireCT=&sourceId=))
11/23/2011 09:54:00.62 w3wp.exe (0x2360) 0x160C SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:https://sharepoint/_layouts/PickerTreeView.aspx?title=CbqPickerSelectListTitle&text=CbqPickerSelectListText&filter=websLists&root=&selection=&featureId=&errorString=&iconUrl=/_layouts/images/smt_icon.gif&scopeToWeb=&requireCT=&sourceId=) a863eba8-9d4b-4880-8da8-b0ec165fd557
11/23/2011 09:54:00.62 w3wp.exe (0x2360) 0x160C SharePoint Foundation Logging Correlation Data xmnv Medium Site=/sites/ARD a863eba8-9d4b-4880-8da8-b0ec165fd557
11/23/2011 09:54:00.65 w3wp.exe (0x2360) 0x160C SharePoint Foundation Runtime tkau Unexpected System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SharePoint.Publishing.Internal.WebControls.ObjectSerializer.evaluateTestAutomationId(CachedList cachedListToEval) at Microsoft.SharePoint.Publishing.Internal.WebControls.ObjectSerializer.get_AutomationId() at Microsoft.SharePoint.Publishing.Internal.WebControls.EcbEnabledTreeNode.RenderPreText(HtmlTextWriter writer) at System.Web.UI.WebControls.TreeNode.Render(HtmlTextWriter writer, Int32 position, Boolean[] isLast, Boolean enabled) at System.Web.UI.WebControls.TreeNode.RenderChildNodes(HtmlTextWriter writer, Int32 depth, Boolean[] isLast, Boolean enabled) at System.Web.UI.WebControls.TreeNode.Render(HtmlTextWriter writer, Int32 position, Boolean[] isLast, Boolean enable... a863eba8-9d4b-4880-8da8-b0ec165fd557
11/23/2011 09:54:00.65* w3wp.exe (0x2360) 0x160C SharePoint Foundation Runtime tkau Unexpected ...d) at System.Web.UI.WebControls.TreeView.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at ASP._layouts_dialog_master.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web... a863eba8-9d4b-4880-8da8-b0ec165fd557
11/23/2011 09:54:00.65* w3wp.exe (0x2360) 0x160C SharePoint Foundation Runtime tkau Unexpected ....UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.SharePoint.WebControls.UnsecuredLayoutsPageBase.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at Microsoft.SharePoint.WebControls.UnsecuredLayoutsPageBase.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) a863eba8-9d4b-4880-8da8-b0ec165fd557
11/23/2011 09:54:00.65 w3wp.exe (0x2360) 0x160C SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://sharepoint/_layouts/PickerTreeView.aspx?title=CbqPickerSelectListTitle&text=CbqPickerSelectListText&filter=websLists&root=&selection=&featureId=&errorString=&iconUrl=/_layouts/images/smt_icon.gif&scopeToWeb=&requireCT=&sourceId=)). Execution Time=28.2707473152521 a863eba8-9d4b-4880-8da8-b0ec165fd557


I decided to use powershell to determine all the IDs of the lists in the site, then browse to the site settings page for each list.


$url = "https://sharepoint/"
$web = Get-SPWeb $url
$web.Lists | SELECT Title,ID


I then took the ID of each list from the output and put it in the List Settings URL:

https://sharepoint/_layouts/listedit.aspx?List=

Until I found the list which loaded as Unknown Error, then I deleted that list using PowerShell:


$list = $web.Lists["ListName"]
$list.Delete()


Voila! The CQWP and Manage Content Structure are now working.

Set URL field in SharePoint using PowerShell

The following PowerShell code is used for updating a URL field in a SharePoint site:


$field = New-Object Microsoft.SharePoint.SPFieldURLValue
$field.Description = "CNN News"
$field.URL = "http://www.cnn.com"

$list = (Get-SPWeb "http://www.domain.com/sites/SharePoint").Lists["Documents"]
$item = $list.Items.Add()
$item["URL"] = $field
$item.Update()


Enabling Incoming Email using PowerShell

I could not find any examples of how to enable incoming email using PowerShell, so I thought this would be a good time to add another post :).


$web = Get-SPWeb http://sharepoint/sites/Team
$list = $web.Lists["Emails"]
# Email alias without the domain (@domain.com)
$list.EmailAlias = "sharepoint"
$list.Update()
# Group attachments in folders, options: "subject"/"sender"/"root"
$list.RootFolder.Properties["vti_emailattachmentfolders"] = "root"
# Overwrite files with the same name, options 1/0
$list.RootFolder.Properties["vti_emailoverwrite"] = 0
# Save original e-mail, options 1/0
$list.RootFolder.Properties["vti_emailsaveoriginal"] = 1
# Save meeting invitations, options 1/0
$list.RootFolder.Properties["vti_emailsavemeetings"] = 0
# Email Security Policy, options 1/0
$list.RootFolder.Properties["vti_emailusesecurity"] = 1
$list.RootFolder.Update()