Home > Uncategorized > SharePoint 2010: The field with Id {GUID} defined in feature {GUID} was found in the current site collection or in a subsite (Case #2)

SharePoint 2010: The field with Id {GUID} defined in feature {GUID} was found in the current site collection or in a subsite (Case #2)

I recently ran into an issue when trying to activate the “PerformancePoint Services Site Collection Features” on a specific site collection and ran into this error:

The field with Id {9cdc5c49-b00d-4224-925f-b5443e27555e} defined in feature {f45834c7-54f6-48db-b7e4-a35fa470fc9b} was found in the current site collection or in a subsite

I’ve also experienced this same error when trying to activate a Site Collection Feature on a site collection that had orphaned content types from Nintex. I blogged about how to resolve that issue here: https://shipoint.com/2012/08/15/fixing-sharepoint-2010-site-collection-feature-activation-error-the-field-with-id-guid-defined-in-feature-guid-was-found-in-the-current-site-collection-or-in-a-sub-site/

However this current issue is a little different than of the Nintex error even though both therotically are caused by orphaned content types. The difference is that Nintex developed a handy tool to help remove these content types where as PerformancePoint did not, and requires more work to clean up.

I’m not so sure how there were orphaned PerformancePoint content types but my assumption here is that data was migrated from one location to another where the source had the Performance Point Services Site Collection Features activated, and the destination site did not.

I’ve ran into orphaned content types in my environment quite a bit and blogged about my cases here:

https://shipoint.com/2013/03/21/remove-orphaned-content-types-in-sharepoint-2010-that-are-associated-with-a-feature/
https://shipoint.com/2013/03/22/fixing-unable-to-locate-xml-definition-for-ctype-with-spcontenttypeid-in-sharepoint-2010/
https://shipoint.com/2012/06/07/removing-a-corrupted-site-column-in-sharepoint-2010/

For this case it’s no different than the others, but I wanted to share with you the steps I took to resolve this particualar problem.

As I did in my previous cases I opened up a case ticket with Microsoft to allow me to do direct DB modifications to successfully remove the orphaned content types. Please open up a ticket with Microsoft so you do not lose your Microsoft premier support.

Upon my first initial investigaion of the error I wanted to check the Site Collection Site Content Types and Site Columns.

When I browsed to “Site actions -> Site Settings -> Site Content Types” I noticed that there was a PerformancePoint Content Type listed there “Performance Data Source” which was associated with the parent content type of “PerformancePoint Monitoring Document Type”.

I then attempted to delete the “Performance Data Source” content type and I got this message: “The content type “PerformancePoint Data Source’ is part of an application feature.

When I attempted to delete the parent content type “PerformancePoint Monitoring Document Type” I received the same error.

I then journed over to SQL and opened up SQL Server Managment Studio 2012.

Below are the steps I took to successfully remove the orphaned content types.
Please proceed with caution. AGain not responsible for your farm.

1. Open up a new Query Window against the database that has the orphaned content type.
2. Typed the following to see if any PerformancePoint content types were present:

SELECT * FROM CONTENTDB.DBO.CONTENTTYPES WHERE ResourceDir like ‘%PerformancePoint%’

Upon running the query I saw two content types for both “Performance Data Source” and “Performance Monintoring Document Type” still in the database and was still tied to a feature. The “isFromFeature” flag was set to “1”.

With the “PerformancePoint Services Site Collection Features” activated it creates 9 root level content types:

PerformancePoint Base
PerformancePoint KPI
PerformancePoint Scorecard
PerformancePoint Indicator
PerformancePoint Report
PerformancePoint Filter
PerformancePoint Dashboard
PerformancePoint Monitoring Document Type
PerformancePoint Data Source

So with only 2 of the 9 content types showing in the database table I knew those content types were somehow orphaned, and for whatever reason the “Performance Monitoring Document Type” and “Performance Data Source” content types were not properally disposed of or removed.

My first initial step was to update the “isFromFeature” flag from “1” to “0” and then delete those content types from the Site Collection Content Types by following this:

https://shipoint.com/2013/03/21/remove-orphaned-content-types-in-sharepoint-2010-that-are-associated-with-a-feature/

However, after doing this I was still unable to delete the content types with the result being the same error as earlier.

I then turned back to SQL to delete the content types directly out of the database.

3. DELETE * FROM CONTENTDB.DBO.CONTENTTYPES WHERE Resource like ‘%PerformancePoint%’

After deleting the content types I tried again to activate the feature and it error’d out again.

Going back to SQL I ran the following query:

4. SELECT * FROM CONTENTDB.DBO.CONTENTTYPES WHERE Definition like ‘%PerformancePoint%’

This returned about 128 different results where PerformancePoint content types were being used in a sub-site within the main Site Collection.

These PerformancePoint content types were:

PPSMA_PersonResonsible
PPSMA_objectXML
PPSMA_FCOImage
PPSMA_FCOSubType

So now I also had to delete those:

5. DELETE * FROM CONTENTDB.DBO.CONTENTTYPES WHERE Definition like ‘%PerformancePoint%’

After deleting the content types, I again tried to activate the feature and it still failed.

Going back to the original error message:

“The field with Id {9cdc5c49-b00d-4224-925f-b5443e27555e} defined in feature {f45834c7-54f6-48db-b7e4-a35fa470fc9b} was found in the current site collection or in a subsite”

I wanted to search for that specific field ID {9cdc5c49-b00d-4224-925f-b5443e27555e} to see if I can find a reference to it in the database.

6. SELECT * FROM CONTENTDB.DBO.CONTENTTYPES WHERE Definition like ‘%27555e%’

It returned results of 32 items all referencing a content type of “DocumentSetDescription”

Since this is the field ID SharePoint was complaning about I deleted them from the database:

7. DELETE * FROM CONTENTDB.DBO.CONTENTYPES WHERE Definition like ‘%27555e%’

Upon deleting these content types I went back to the site and attempted to activate the feature again.

This time the feature activated successfully and all the correct content types for PerformancePoint were added to the Site Content Types and the database.

Hopefully this will help others who might run into a similar problem in your environment.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: