Folder and Table locked and not removable

miguelcalzada — Fri, 13 Mar 2020 10:45:45 GMT

Hello there,

Some users had disconnection problems caused by network, and some of the metadata objects they were working on got locked, and neither them or the administrator can delete, rename or modify anything about them.

They don't let you choose the Delete option from the SAS Management Console, and when you try to rename it, it shows a locked message. You can find proof of both of those things on the attachments for one table that has that problem, and another folder (not in the same route) has this same problem as well.

We have tried to repair the Metadata in the Metadata Manager, but it didn't work, and recovering a Metadata backup from some time ago is not an option.

Any help will be appreciated.

Thank you everyone!

Re: Folder and Table locked and not removable

Kalind_Patel — Fri, 13 Mar 2020 13:14:24 GMT

There's an option called OMI_UNLOCK_FORCE in Metadata update procedures, you can use that option to unlock the locked table, here's a sample code,

But, I strongly recommend to take the Metadata Backup first before you execute this SAS Code,

Here's the sample code for SAS 9.4:

options metaserver='YOUR_METADATA_SERVER'
metaport=8561
metaprotocol='bridge'
metauser='sasadm@saspw'
metapass='PASSWORD_FOR_SASADM'
metarepository='Foundation'
;

options ls=max ps=max noquotelenmax ;
proc metadata
in='<GetMetadata>
    	<Metadata>
        <PhysicalTable Id="INSERT_YOUR_PHYSICAL_TABLE's_ID_HERE" />
    	</Metadata>
    		<NS>SAS</NS>
    	<Flags>262144</Flags>
    	<Options>
    	</Options>
    </GetMetadata>' 
verbose;
run;

Make sure you change metaserver, metapass and most importantly "PhysicalTable Id" value in this code, You can get PhysicalTable's Id from you error message itself:

After running this code, the Table should be unlocked.

For your reference: https://documentation.sas.com/?docsetId=omaref&docsetTarget=n0jz5u1b73d8czn1wil2biqcusr5.htm&docsetVersion=9.4&locale=en

topic Folder and Table locked and not removable in Administration and Deployment

Folder and Table locked and not removable

Re: Folder and Table locked and not removable