Failure to delete a collection in Purview

sjmonteiro 6 Reputation points
2022-11-30T15:51:26.193+00:00

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.
265822-image.png

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,224 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Ian Santillan 197 Reputation points
    2022-11-30T16:21:56.023+00:00

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


  2. Mariusz Pyśk 0 Reputation points
    2024-07-19T09:19:56.27+00:00

    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: https://purview.microsoft.com/
    2. Once it opens, URL includes tid: https://purview.microsoft.com/home?tid=1234a123-1aef-123a-a123-1d12345678be
    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:

    https://purview.microsoft.com/home?tid=1234a123-1aef-123a-a123-1d12345678be&feature.ext.catalog={"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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.