While I tried to migrated the SharePoint 2010 Data base to SharePoint 2016 through the database upgrade approach , I received the below missing feature error
Database [database] has reference(s) to a missing feature: Name = [PowerPivot Feature
Integration for Site Collections], Id = [1a33a234-b4a4-4fc6-96c2-8bdb56388bd5
usually if you follow this blog Link, you should be able to clean up the missing feature , if not by using the feature admin tool you should be able to clean up the faulty feature at the source . But in this case neither worked . SharePoint 2010 was not showing that this feature was activated , but the upgrade was failing in SharePoint 2013/2016 .
Hence i decide to do some digging myself in SQL and try to resolve the issue , below are the steps followed to resolve the issue
Database [database] has reference(s) to a missing feature: Name = [PowerPivot Feature
Integration for Site Collections], Id = [1a33a234-b4a4-4fc6-96c2-8bdb56388bd5
usually if you follow this blog Link, you should be able to clean up the missing feature , if not by using the feature admin tool you should be able to clean up the faulty feature at the source . But in this case neither worked . SharePoint 2010 was not showing that this feature was activated , but the upgrade was failing in SharePoint 2013/2016 .
Hence i decide to do some digging myself in SQL and try to resolve the issue , below are the steps followed to resolve the issue
1. Open
SSMS in source (SharePoint 2010 /2013), run the below script to find the tables
in DB where the missing feature is referenced
USE [Name of the DB]
GO
SELECT t.name
AS table_name,
SCHEMA_NAME(schema_id) AS
schema_name,
c.name
AS column_name
FROM sys.tables AS t
INNER JOIN
sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name
LIKE '%FeatureId%'
ORDER BY schema_name,
table_name;
2. Query
result would provide the list of tables in SQL
table_name
schema_name column_name
AllLists
dbo
tp_FeatureId
CustomActions
dbo
FeatureId
Features
dbo
FeatureId
FeatureTracking
dbo
FeatureId
3. Open
up each table in SQL and identify the row as per sample query
Select * from [data base name].[dbo].[tablename] where
tp_featureID = ‘guid of
missing feature’
Results would provide the webID of the website
4. Open
up any of the SharePoint server in the farm and execute the below query , this
would list all the site and webs with the ID
5
Get-SPWebApplication http://sharepoint.dev.symetra.com/
| Get-SPSite -Limit All | Get-SPWeb -Limit All | Select Title, URL, ID,
ParentWebID | Export-CSV C:\InfoArch.csv –NoTypeInformation
6. Navigate
to the website and clean up the component which is referred by the feature .
I In my case there was a faulty power pivot library at SharePoint 2010 , I went ahead and cleaned up the library at 2010
