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

[swapnil9099]

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}

[jklaverstijn]

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.