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

ERROR: Metadata Server denied access to operation.

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

ERROR: Metadata Server denied access to operation.

im getting this error. while refresh the LASR data through windows batch run(scheduling).

 

NOTE: Libref CSLASR was successfully assigned as follows: 
Engine: SASIOLA 
Physical Name: SAS LASR Analytic Server engine on local host, port 10081
NOTE: Building actions list
NOTE: SCANNING 
DB.ACTIVE_HEADERS_DATA|DB.ALERT_INVESTIGATION_EXTRACT|DB.CS_USER_INFO_GROUPS|DB.JOBS_STATS_DETAIL|DB.JOBS_STATS_SUMMARY|DB.LIST_REPO
RT_DATA|DB.RISK_CLASSIFIER_REPORT_DATA|DB.SCENARIOS_AND_RISK_DATA|DB.SCENARIO_CHANGE_HISTORY_DATA|DB.USER_GROUP_ROLE_TOTALS
---------------------------------------------------
REFRESHING DB.ACTIVE_HEADERS_DATA (SQUEEZE=NO) IN LASR
---------------------------------------------------
NOTE: REMOVE FROM LASR
ERROR: Metadata Server denied access to operation.
NOTE: LOAD TO LASR

ERROR: Metadata Server denied access to operation.
ERROR: Write access to member CSLASR.ACTIVE_HEADERS_DATA.DATA is denied.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 1.51 seconds
user cpu time 0.00 seconds
system cpu time 0.03 seconds
memory 1978.93k
OS Memory 20320.00k
Timestamp 06/15/2018 06:50:37 PM
Step Count 2976 Switch Count 22


Accepted Solutions
Solution
‎06-15-2018 10:57 AM
SAS Super FREQ
Posts: 556

Re: ERROR: Metadata Server denied access to operation.

[ Edited ]
Posted in reply to kuppusamy

@kuppusamy,

 
Thanks. You do not have access for this table in the metadata:

** Access Denied **^M
Action: 7^M
Tag and Table name: CSDATA.ACTIVE_HEADERS_DATA^M
User: itsoftadmin@PMCDC^M
Required Permission: Read on Table object^M

Please adjust the permissions on the table object in SAS Management Console.

View solution in original post


All Replies
SAS Super FREQ
Posts: 556

Re: ERROR: Metadata Server denied access to operation.

Posted in reply to kuppusamy

@kuppusamy,

 

I would like to see the following log file from the middle tier: /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.<X>.log

Contributor
Posts: 21

Re: ERROR: Metadata Server denied access to operation.

authorization log file

Solution
‎06-15-2018 10:57 AM
SAS Super FREQ
Posts: 556

Re: ERROR: Metadata Server denied access to operation.

[ Edited ]
Posted in reply to kuppusamy

@kuppusamy,

 
Thanks. You do not have access for this table in the metadata:

** Access Denied **^M
Action: 7^M
Tag and Table name: CSDATA.ACTIVE_HEADERS_DATA^M
User: itsoftadmin@PMCDC^M
Required Permission: Read on Table object^M

Please adjust the permissions on the table object in SAS Management Console.

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 282 views
  • 0 likes
  • 2 in conversation