Notes from the Field: Upgrading SharePoint

Over the years, much has been written about upgrading SharePoint.  TechNet has some very good resources (links below) that provide process overviews, checklists, etc.  I encourage you to review this content prior to beginning an upgrade of SharePoint.  So what is the real point of this post?  While the referenced material and many other resources…


One-time Timer Jobs fail to start

I recently ran into an issue with a SharePoint 2013 farm in which one-time timer jobs were failing to run.  This was impacting the ability to deploy solutions, run Merge-SPLogFile, etc.  When running Merge-SPLogFile from an app server, it kept failing on the web front ends (WFEs) with a message of “WARNING:  Unable to start job…

1

Updating the User Information List

SharePoint site collections contain a hidden list called the User Information List (UIL).  This list contains one entry for every user who has accessed the site collection or been given explicit rights within the site collection.  The list holds basic profile information.  In a farm that is not using a User Profile Application (UPA), most…

1

Adventures in SharePoint 2010 Workflow Troubleshooting

I recently had a customer who was encountering issues with the SharePoint 2010 Workflow timer job.  The issue would cause the Workflow timer job to hang.  Other timer jobs would execute successfully, but the Workflow timer job would remain in either a “running” or a “pausing” state.  Recycling the timer service would temporarily resolve the…


Removing a user’s site collection administrator privileges and security group memberships

A peer of mine, Jonathan Dimino, recently wrote a post on his TechNet blog to provide a PowerShell script for changing the Primary and Secondary site collection administrators assigned to a site collection.  Along with replacing the Primary/Secondary site collection administrators, it is sometimes necessary to remove a user from all site collection administrator privileges and…


The Undocumented "Feature" of Mount-SPContentDatabase

Today we are going to look at an undocumented (as of 8/6/14) functionality related to the Mount-SPContentDatabase PowerShell command for SharePoint 2010/2013.  If you are unfamiliar with this command, I suggest reviewing the TechNet documentation, which can be found here.  I was doing some migration testing for a customer recently and had to mount some…

2

Configuring Kerberos so SSRS 2012 reports can consume SharePoint 2010 as a data source

I recently had the need to configure Kerberos constrained delegation for SQL Server Reporting Services 2012 (SSRS) that was running in SharePoint Integrated Mode in a SharePoint 2010 farm.  SSRS reports needed to leverage the “XML” data source and consume the SharePoint web services (such as “listdata.svc”).  The documentation for configuring this scenario is scattered…


Sandboxed Solutions – Who is Sharing My Process Space?

I recently ran into an interesting scenario with SharePoint 2010 Sandboxed Solutions while working a customer engagement.  While your scenario is not likely to be exactly like my customer’s, the underlying behavior of the Sandbox could potentially lead to similar symptoms.  Hopefully, this post saves you some troubleshooting time. In my scenario, the customer had…


SharePoint 2010 Web Analytics – Changing the Schedule

If you ever tried to change the processing schedule or manually run the processes for the SharePoint 2010 Web Analytics, you probably realized fairly quickly that it is a less-than-intuitive and rather frustrating endeavor.  Hopefully this post can demystify some of the moving pieces for you. Web Analytics has several timer jobs.  Web Analytics data…