January 17, 2017

SharePoint: Yet another way to remove orphan SSRS Content Types


In a SharePoint Web Application, SQL Server Reporting Services was installed when farm was on SharePoint 2010 level. Since then, the farm had been upgraded to SharePoint 2013 using content database upgrade method. New servers were set up for the new farm.

History is history, but for some reason, orphan SSRS Content Types were left on the site collection breaking when attempting to create team sites based on a template. In the saved site template there was references to Content types with names such as

“$Resources:ReportServerResources,ReportBuilderContentTypeName;” and “$Resources:ReportServerResources,ReportBuilderModelName;”,

but subsite creation failed as it couldn’t find such content types. On the content type list of the site collection, you could see three content types with those exact names, meaning something was missing as valid names of the content types couldn’t be shown.


  1. Installed SSRS components on the new farm using (SKIPCA skips the custom action phase, as it was not succeeding in our case):

    Msiexec.exe /i rsSharePoint.msi SKIPCA=1
  2. This makes the content type names behave correctly.
  3. Now you can install the ReportServer feature

    Install-SPFeature -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\FEATURES\ReportServer"
  4. Followed by uninstalling that same feature

    Uninstall-SPFeature -Identity e8389ec7-70fd-4179-a1c4-6fcb4342d7a0
  5. And finally you can just uninstall the rsSharePoint.msi for good

    msiexec.exe /uninstall rsSharePoint.msi

No comments:

Post a Comment