Cant Edit Authorization due to access controls for table blocked by a loaded table of the same name

swapnil9099 — Thu, 20 Oct 2022 16:17:58 GMT

Hi,

We ran into an issue where we are unable to edit authorization anymore in SAS Environment Manager due to a lock created on the table.

Can someone guide us step by step mechanism to release the table lock?

Please find the error details below:

{"errorCode":12501,"message":"The action was not successful. (2-6-2640670)","details":["traceId: bce3a811dfbfb466","path: /casAccessManagement/servers/cas-shared-default/caslibs/TRANSFORMATION_MART/tableControls/<table_name>/lock","NOTE: The access controls for table <table_name> are being blocked by a loaded table of the same name.","ERROR: The action stopped due to errors.","0x887fc29e:PERM_TABLE_BLOCKED"],"remediation":"Ensure that specified CAS object (Caslib, table, column, action, etc.) exists and has access control(s).","links":[],"version":2,"httpStatusCode":500}

Re: Cant Edit Authorization due to access controls for table blocked by a loaded table of the same n

jklaverstijn — Fri, 21 Oct 2022 13:05:55 GMT

There are a few reasons why one cannot edit authorizations on a table. They are documented in the paragraph "Inability to Modify Access" in the SAS Viya 3.5 Administration documentation. Have a look and let us know if the suggestions were applicable to your case.

Hope this helps,

- Jan.

topic Cant Edit Authorization due to access controls for table blocked by a loaded table of the same name in Administration and Deployment

Cant Edit Authorization due to access controls for table blocked by a loaded table of the same name

Re: Cant Edit Authorization due to access controls for table blocked by a loaded table of the same n