Deleting Metadata sets

bwmyers's Avatar

bwmyers

22 Jul, 2015 11:38 PM

I am in the process of cleaning up some old sites in our CMS. When I try and delete a complete site the system comes back and gives me a couple cross site errors. One of them concerns a metadata set that is in the site and is being used by another site. Problem I am having is that I don't know which site is using it. We have 31 sites. Normally when I delete something out of the system it tells me what assets are using it. In this case when I go to delete the metadata set it kicks an error. See screenshots.

Is there a quick way to figure out which site is using the metadata set?

  1. 1 Posted by Ryan Griffith on 23 Jul, 2015 11:41 AM

    Ryan Griffith's Avatar

    Hi Bradley,

    The error message in your second screenshot is due to a restriction in place that does not allow the deletion of the Default Metadata Set, because it is the default used for asset factories and the Site itself. I'm not certain, but I believe I recall an improvement logged to hide the Delete tab all-together to avoid the confusion.

    To get the Site(s) that may be using the Metadata Set, first obtain the Metadata Set's ID by copying it from the URL (ie after the id= parameter) and run the following query:

    select id from cxml_site where metadataId = 'METADATA_ID';
    

    Where METADATA_ID is the ID you obtained from the URL.

    Please let me know if you have any questions.

    Thanks!

  2. 2 Posted by bwmyers on 23 Jul, 2015 04:36 PM

    bwmyers's Avatar

    Ryan,

    The query returned an empty data set.

  3. 3 Posted by Ryan Griffith on 23 Jul, 2015 07:24 PM

    Ryan Griffith's Avatar

    Hi Bradley,

    When you have a moment, let's try a slightly different query and let me know if it returns anything:

    select id from cxml_site where defaultMetadataSetId = 'METADATA_ID';
    

    Where METADATA_ID is the ID you obtained from the URL.

    Please let me know if you have any questions.

    Thanks!

  4. 4 Posted by bwmyers on 28 Jul, 2015 11:32 PM

    bwmyers's Avatar

    We can close this out. Instead of trying to hunt down the owner I just moved it to a different site.

  5. bwmyers closed this discussion on 28 Jul, 2015 11:32 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac