Problem deleting metadata objects

[Nigel_Pain]

SAS 9.4M7 on 4 Windows Server 2019 platforms (metadata, compute, mid-tier, LASR)

I was doing a bit of tidying up of metadata folders, specifically removing the user folders of people who no longer have access. I found a couple of Visual Data Queries for one such user but I am unable to delete them. I'm using the sasadm@saspw account and have ensured that metadata permissions are set on them and their containing folder to allow me to do this. But I'm getting an error message:

Nigel_Pain_0-1709893809246.png

Any suggestions?

Thanks.

[JosvanderVelden · Accepted solution]

Can you verify if the solution provided in note https://support.sas.com/kb/57/237.html also solves the issue in your case?

[Nigel_Pain]

Thanks, that did the trick. I wondered if there was a way to do it programmatically but I haven't delved  much into changing metadata that way.

[Resa]

Coincidentally we encountered the same issue as the OP on the same day, so we as well have tried the proposed solution.

The only thing that we have noticed that it took us up to three tries to delete all objects.

In other words, during the first try we got an rc of -3 on some of the objects and on most of the objects an rc of 0.
During the second try we had an rc of 0 on the remaining objects but one. The third try removed the final one.

[gwootton]

An rc of -3 from metadata_delobj means it couldn't find the supplied ID. My guess would be that was an issue of the order of the metadata_resolve and metadata_delobj functions if it was modified to run for multiple objects.