topic Re: Problem deleting metadata objects in Administration and Deployment

Problem deleting metadata objects

Nigel_Pain — Fri, 08 Mar 2024 10:31:55 GMT

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:

Any suggestions?

Thanks.

Re: Problem deleting metadata objects

JosvanderVelden — Mon, 11 Mar 2024 15:12:20 GMT

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

Re: Problem deleting metadata objects

Nigel_Pain — Tue, 12 Mar 2024 10:15:30 GMT

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.

Re: Problem deleting metadata objects

Resa — Tue, 12 Mar 2024 10:51:15 GMT

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.

Re: Problem deleting metadata objects

gwootton — Tue, 12 Mar 2024 14:29:17 GMT

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.