Failure to delete a collection in Purview

sjmonteiro 6 Reputation points

I am trying to delete a collection in Purview after having deleted all sub-collections and sources it held. When I try to delete it, it gives following error: "Request failed with status code 409 Request ID: 18de444b-c1fc-419f-b31a-c1e84004534d The collection Insurance (3xgrul) is being referenced by other resources and can't be deleted." I've checked if there is a solution for it, however, I can't seem to find one.

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,059 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Ian Santillan 197 Reputation points

    As per the error message, what other resource is referencing this collection?

  2. Mariusz Pyśk 0 Reputation points

    Hi I've contacted with Microsoft support which helped me with this issue.

    It turned out collection contained zero-size assets, which were not deleted when I've deleted scan.

    To find and delete such objects, I've followed these steps:

    1. Open Purview:
    2. Once it opens, URL includes tid:
    3. At the end of the url add parameter: &feature.ext.catalog={"enableToggleEmptyFile":"true"} this option allows to show or hide empty files (zero size files), url after modification will lok like:{"enableToggleEmptyFile":"true"}

    1. In the search text box on te top of the screen put ***** (star) and confirm by enter - it will search for all files
    2. Click "View all in Data Catalog" on the right
    3. Switch off "Hide zero-size file" option
    4. Select collection in the filters to display assets related to the problematic collection
    5. delete zero size assets
    6. Delete collection

    I hope this solution can help if anybody have the same issue.

    0 comments No comments