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

Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

Accepted Solution Solved
Reply
Super Contributor
Posts: 339
Accepted Solution

Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

[ Edited ]

I keep getting this error on one of my VA tables. Others are working fine and I've checked the permissions that it's the same for all the tables.

 

Other infor:

  • This is executed through Windows Task Scheduler by a service account (with logon as batch job permissions)
  • Service account has full control on physical paths related to VA(Monitoring, PID, Logs, etc)
  • Service account triggers the task but internal account sasadm@saspw is used to initialized the LASR library 
  • The task runs 2 times daily. One at 7:45am then another at 1:45pm. The morning one always fails and the afternoon completes w/o errors. Does the SAS Auto-load do something with it? Our Auto-Load task runs every hour (6am, 7am, ...).

 

Any idea how to resolve such error?

 

MPRINT(RELOADINTOLASR):   data LASRLIB.vatable;
MPRINT(RELOADINTOLASR):   set saslib.source;
MPRINT(RELOADINTOLASR):   run;

ERROR: Metadata Server denied access to operation.
ERROR: Member or library LASRLIB.VATABLE.DATA unavailable for use.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1062 observations read from the data set SASLIB.SOURCE.
WARNING: The data set LASRLIB.vatable may be incomplete.  When this step was stopped there were 1062 observations and 18 variables.
ERROR: Metadata Server denied access to operation.
ERROR: Member or library LASRLIB.VATABLE.DATA unavailable for use.

 


Accepted Solutions
Solution
‎04-11-2018 09:07 PM
SAS Super FREQ
Posts: 548

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

@milts,

So it seems that it's some network issue that suddenly connection gets tripped between our Metadata and VA Server.

Yes.

Sorry for the silly question, but what is an ICF?

ICF stands for Isolated Customer Fix.

View solution in original post


All Replies
Super User
Posts: 4,016

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

[ Edited ]

If the afternoon job is successful and the morning one is not then there must be something different about the morning one that is causing the errors. Is there anything different about the two jobs, either in the jobs themselves, or in the way they are set up?

 

Is your service account defined in SAS metadata?

 

This post might be helpful:

https://communities.sas.com/t5/SAS-Visual-Analytics/Unable-to-unload-table-from-LASR-quot-Metadata-S...

Super Contributor
Posts: 339

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

Both jobs are identical except for the task name. Batch script being called is also the same that's why it's strange.

 

Service account is not defined in SAS Metadata.

 

I'll be checking the logs based from the link you have shared and update you again.

 

Anyway, I was trying to check other factors. I have another task which also loads a different set of sas datasets to VA. When the faulty task above triggers, the other task is actually running. Is there some limitation on the concurrency of tables that can be loaded to VA?

SAS Super FREQ
Posts: 548

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

@milts,

 

Have you seen any errors in /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.<X>.log?

Super Contributor
Posts: 339

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

Hi @alexal,

 

I'm unable to post the entire log here as it's on the client's server. But yes, there are some errors in the log file which starts with this line

 

com.sas.lasr.LASRException: java.net.SocketTimeoutException: Read Timed Out

 

Could this be some network problem? But strange thing is that my other task which that is also doing some loading to LASR library and even has bigger tables was loaded successfully.

 

An observation from today's batch is that it still failed. Then triggered a rerun of the batch and it was loaded successfully. Is there such thing that the LASR library gets too busy loading multiple tables to VA that the connection for incoming ones our dropped?

 

Apologies if my thoughts on the error are a bit odd as I am not fully knowledgeable on how VA works in the back end.

 

SAS Super FREQ
Posts: 548

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

@milts,

com.sas.lasr.LASRException: java.net.SocketTimeoutException: Read Timed Out

Could this be some network problem? But strange thing is that my other task which that is also doing some loading to LASR library and even has bigger tables was loaded successfully.

 

I assume you are either on SAS 9.4 M3 or M4. Am I right? If my assumption is correct, this is a network problem with communication between LASR Authorization Service and the metadata server. The metadata server didn't respond within 2s. 2s is the default timeout for M3 and M4. That can be increased by installing ICF. What is the sas.lasr.mgmt version in your /<SASConfig>/Lev<X>/Web/WebAppServer/SASServer12_1/sas_webapps/sas.lasr.authorization.war/WEB-INF/picklist?

 

Occasional Contributor
Posts: 9

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

Hi @alexal ,
Can you please explain how to increase the timeout value between LASR Authorization Service and the metadata server?

Thanks
SAS Super FREQ
Posts: 548

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

Posted in reply to NunoTGrunho

@NunoTGrunho,

 

You have to open a technical support track. Once you do that, send me its number.

Super Contributor
Posts: 339

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

Hi @alexal,

 

Sorry for the late response as I just managed to check today.

 

Version for sas.lasr.mgmt in the picklist is 703000.0.1.201504031272710.d4bicomr9

 

I was trying to monitor the behavior as well the past few days of the servers. Yesterday's run completed without any problems. Today's run failed. I tried to rerun it and the first one failed, and another run was successful. So it seems that it's some network issue that suddenly connection gets tripped between our Metadata and VA Server.

 

Sorry for the silly question, but what is an ICF? Is this something that will ensure that connection across SAS Servers are always up?

 

Thanks again for the assistance!

Solution
‎04-11-2018 09:07 PM
SAS Super FREQ
Posts: 548

Re: Metadata Server Denied Access to Operation when loading SAS dataset to VA Public LASR

@milts,

So it seems that it's some network issue that suddenly connection gets tripped between our Metadata and VA Server.

Yes.

Sorry for the silly question, but what is an ICF?

ICF stands for Isolated Customer Fix.

☑ This topic is solved.

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

Discussion stats
  • 9 replies
  • 609 views
  • 3 likes
  • 4 in conversation