Share via

SharePoint 2010: Quick Deploy Items List Causes Sites to Fail to Upgrade.

  • Article

Scenario

 Sites fail to upgrade when you run the Upgrade-SPContentDatabase cmdlet against a Content Database after one of the following conditions:

  • Applying a CU (Cumulative Update) / Service Pack 
  • Upgrade from 2007 to 2010

Error

In the upgrade log you will see this error.
[powershell] [SPContentDatabaseSequence] [INFO] [10/1/2013 4:10:01 PM]: SPContentDatabase Name=ContentDatabaseName
[powershell] [SPContentDatabaseSequence] [WARNING] [10/1/2013 4:10:01 PM]: WebTemplate ID 1005 (lcid: 1033), provisioned in ContentDatabase ContentDatabaseName, is missing.
[powershell] [SPContentDatabaseSequence] [INFO] [10/1/2013 4:10:01 PM]: SPContentDatabase Name=ContentDatabaseName
[powershell] [SPContentDatabaseSequence] [WARNING] [10/1/2013 4:10:01 PM]: WebTemplate ID 1005 (lcid: 1033), provisioned in ContentDatabase ContentDatabaseName, is missing.
[powershell] [SPSiteWssSequence2] [INFO] [10/1/2013 4:10:24 PM]: SPSite Url=https://SitecolelctionURL
[powershell] [SPSiteWssSequence2] [ERROR] [10/1/2013 4:10:24 PM]: Feature upgrade incomplete for Feature 'PublishingSite' (Id: 'a24d36-2fa8-4f0b-b16d-06b7250180fa') in Site ' https://SitecolelctionURL. Exception: The parent content type specified by content type identifier 0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF39 does not exist.
[powershell] [SPSiteWssSequence2] [INFO] [10/1/2013 4:10:24 PM]: SPSite Url= https://SitecolelctionURL
[powershell] [SPSiteWssSequence2] [ERROR] [10/1/2013 4:10:24 PM]: Feature upgrade incomplete for Feature 'PublishingSite' (Id: 'a24d36-2fa8-4f0b-b16d-06b7250180fa') in Site ' https://SitecolelctionURL. Exception: Provisioning did not succeed. Details: Failed to create the 'Quick Deploy Items' list. OriginalException: Column Limit Exceeded.
There are too many columns of the specified data type. Please delete some other columns first. Note that some column types like numbers and currency use the same data type.  (Inner Exception: Column Limit Exceeded.
​There are too many columns of the specified data type. Please delete some other columns first. Note that some column types like numbers and currency use the same data type.)
[powershell] [SPSiteWssSequence2] [INFO] [10/1/2013 4:10:28 PM]: SPSite Url= https://SitecolelctionURL
[powershell] [SPSiteWssSequence2] [ERROR] [10/1/2013 4:10:28 PM]:

Solution

  • Go to the site collection > site settings> Under the Site Collection Administration > Site collection features

  • Or direct URL:http://sitecolelctionName/_layouts/ManageFeatures.aspx?Scope=Site

  • On this page **deactivate **this Feature: "SharePoint Server Publishing Infrastructure"

  • Now Run the Blow mentioned Script to Delete the** Quick Deploy Items List **(Don't worry about deletion, this will back once you Activate the Feature Again)

  • Open the SharePoint Management Shell

    $webSite = Get-SPWeb "https://SiteCollection"            
$List=$webSite.Lists["Quick Deploy Items"];            
$List.AllowDeletion=$True;            
$List.update();            
$List.delete();

  • Now **Activate **the "SharePoint Server Publishing Infrastructure" feature, it will be successfully activated.

  • Finally, run the upgrade Command and it will complete successfully.