topic Re: ERROR: Metadata Server denied access to operation. in SAS Visual Analytics

ERROR: Metadata Server denied access to operation.

kuppusamy — Fri, 15 Jun 2018 13:31:32 GMT

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

Re: ERROR: Metadata Server denied access to operation.

alexal — Fri, 15 Jun 2018 13:36:45 GMT

@kuppusamy,

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

Re: ERROR: Metadata Server denied access to operation.

kuppusamy — Fri, 15 Jun 2018 13:43:49 GMT

authorization log file

Re: ERROR: Metadata Server denied access to operation.

alexal — Fri, 15 Jun 2018 13:53:12 GMT

@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.