topic Re: Unable to unload table from LASR ("Metadata Server denied access to operation") in SAS Visual Analytics

Unable to unload table from LASR ("Metadata Server denied access to operation")

rodrigo_pereira — Mon, 21 Aug 2017 09:59:31 GMT

Hello Experts,

I'm trying to unload data from LASR Server through the Administrator in VA (version 7.1) and I'm having issues for some tables.

The steps I did were:

1) In Administrator, LASR -> Manage Tables

2) For the desired tables, "Unload" button

I'm getting a failure message and when I check the log I see the following error description: "Metadata Server denied access to operation".

Do you know why this could happen?

Thank you in advance,

Rodrigo

Re: Unable to unload table from LASR ("Metadata Server denied access to operation")

alexal — Mon, 21 Aug 2017 12:17:55 GMT

@rodrigo_pereira,

First of all, make sure that you have these permissions on the metadata server:

LASR Server, LASR Library, and the metadata folder associated with LASR library - ReadMetadata (RM)
Table - ReadMetadata (RM), Read (R), Write (W)

All required permissions are listed in VA Admin Guide -> Permissions by Task (page 33). If you have these permissions, please send this file from the middle tier along with a table name:

/<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.1.log

Re: Unable to unload table from LASR ("Metadata Server denied access to operation")

rodrigo_pereira — Mon, 21 Aug 2017 13:57:33 GMT

Hello alexal,

Thank you.

It was indeed a permissions issue. I added the roles "Metadata Server: Operation", "Metadata Server: Unrestrited" and "Metadata Server: User Administration" to my user and the problem was solved.

I also noticed that the log "SASLASRAuthorization7.1.log" has already 839 MB. There is any way to shrink the log? Maybe delete the file?

Thank you for your support. I'm a little newby in these SAS administration tasks.

Rodrigo

Re: Unable to unload table from LASR ("Metadata Server denied access to operation")

alexal — Mon, 21 Aug 2017 14:04:56 GMT

@rodrigo_pereira,

You are welcome!

>> There is any way to shrink the log?

Just run this command from Linux console

> /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.1.log

Re: Unable to unload table from LASR ("Metadata Server denied access to operation")

rodrigo_pereira — Mon, 21 Aug 2017 14:24:47 GMT

Sorry alexal, which command?

rm <file> to remove the log ?

Re: Unable to unload table from LASR ("Metadata Server denied access to operation")

alexal — Mon, 21 Aug 2017 14:31:32 GMT

@rodrigo_pereira,

> /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.1.log