Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Accepted Solution Solved
Reply
Contributor
Posts: 26
Accepted Solution

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

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


Accepted Solutions
Solution
‎08-21-2017 09:58 AM
SAS Super FREQ
Posts: 561

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

Posted in reply to rodrigo_pereira

@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

View solution in original post


All Replies
Solution
‎08-21-2017 09:58 AM
SAS Super FREQ
Posts: 561

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

Posted in reply to rodrigo_pereira

@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
Contributor
Posts: 26

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

[ Edited ]

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

 

 

SAS Super FREQ
Posts: 561

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

[ Edited ]
Posted in reply to rodrigo_pereira

@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

 

Contributor
Posts: 26

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

Sorry alexal, which command?

 

rm <file> to remove the log ?

SAS Super FREQ
Posts: 561

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

Posted in reply to rodrigo_pereira

@rodrigo_pereira,

 

> /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.1.log
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 1520 views
  • 1 like
  • 2 in conversation