BookmarkSubscribeRSS Feed
kuppusamy
Fluorite | Level 6

NOTE: LOAD TO LASR

NOTE: There were 504 observations read from the data set DB.ACTIVE_HEADERS_DATA.
NOTE: The data set CSLASR.ACTIVE_HEADERS_DATA has 504 observations and 22 variables.
ERROR: Metadata Server denied access to operation.

ERROR: 1016: Metadata Server denied access to operation.
---------------------------------------------------
REFRESHING DB.ALERT_INVESTIGATION_EXTRACT (SQUEEZE=NO) IN LASR
---------------------------------------------------
NOTE: REMOVE FROM LASR
ERROR: Metadata Server denied access to operation.
NOTE: LOAD TO LASR

ERROR: Unable to connect to Metadata Server.
ERROR: Write access to member CSLASR.ALERT_INVESTIGATION_EXTRACT.DATA is denied.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2018-06-18T18:17:06,031+05:1800| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM|
| _DISARM| 230789120| _DISARM| 33144832| _DISARM| 10| _DISARM| 28| _DISARM| 721920| _DISARM| 24486126294| _DISARM| 0.015600|
_DISARM| 0.374000| _DISARM| 1844945225.658000| _DISARM| 1844945226.032000| _DISARM| 0.000000| _DISARM| | _ENDDISARM
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 2187.68k
OS Memory 33528.00k
Timestamp 18/06/2018 06:17:06 PM
Step Count 9067 Switch Count 56

12 REPLIES 12
alexal
SAS Employee

@kuppusamy,


Who starts the autoload process? Are you sure that user exists in the metadata?

kuppusamy
Fluorite | Level 6

yes, the user is a super user. before it is running properly, even morning it worked fine, but now im getting this error.

manial
Obsidian | Level 7

@kuppusamy Could you please check if the super user got unrestricted role in smc.

Ideally unrestricted metadata shouldn't be part of the users role.

 

Best Regards,

Manas

kuppusamy
Fluorite | Level 6

there is one metadata server: unrestricted role. the role is not assigned to that user.

kuppusamy
Fluorite | Level 6

there is one metadata server: unrestricted role. the role is not assigned to that user.

 

morning also i run the same job with same user.

alexal
SAS Employee

@kuppusamy,

 

Please repeat the problem and show me the most recent metadata server log as well as /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASLASRAuthorization7.<X>.log from the middle tier. Also, I need to know the user ID.

kuppusamy
Fluorite | Level 6

yes i got this error:

 

APP 2018-06-12 09:01:39,644 WARN [ST-45191-chOqGVumzyhQg3E3z3aD-cas itsoftadmin] com.sas.lasr.authorization.service.AuthorizationServiceImpl - ** Access Denied **
APP 2018-06-12 09:01:39,645 WARN [ST-45191-chOqGVumzyhQg3E3z3aD-cas itsoftadmin] com.sas.lasr.authorization.service.AuthorizationServiceImpl - Action: 7
APP 2018-06-12 09:01:39,645 WARN [ST-45191-chOqGVumzyhQg3E3z3aD-cas itsoftadmin] com.sas.lasr.authorization.service.AuthorizationServiceImpl - Tag and Table name: CSDATA.ACTIVE_HEADERS_DATA
APP 2018-06-12 09:01:39,646 WARN [ST-45191-chOqGVumzyhQg3E3z3aD-cas itsoftadmin] com.sas.lasr.authorization.service.AuthorizationServiceImpl - User: itsoftadmin@PMCDC
APP 2018-06-12 09:01:39,646 WARN [ST-45191-chOqGVumzyhQg3E3z3aD-cas itsoftadmin] com.sas.lasr.authorization.service.AuthorizationServiceImpl - Required Permission: Read on Table object

 

but i gave all rights to that user(dataset wise). 

alexal
SAS Employee

@kuppusamy,

 

That user doesn't' have read permissions on ACTIVE_HEADERS_DATA table object.

kuppusamy
Fluorite | Level 6

i already gave all rights like r,rm,w,wm,create,delete,administer,checkinmetada everything.

alexal
SAS Employee

@kuppusamy,

 

Please show me a screenshot from "Explore Authorizations" for that user. Please do that on the table object.

alexal
SAS Employee

@kuppusamy,

 

Are you sure you have no duplicates for that entry? Try to delete it and run the autoload process once again.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 12 replies
  • 3326 views
  • 0 likes
  • 3 in conversation