Usage Note 57907: SAS® Visual Data Builder scheduling might fail with "ERROR: Unauthorized: Check username/password"
When you attempt to schedule a query, SAS Visual Data Builder might display the following errors in the log for the job:
ERROR: Unauthorized: Check username/password.
ERROR: Write access to member LASRLIB.[tablename].DATA is denied.
The SASAuthorizationServices.log
might contain errors that are similar to these:
2016-03-18 10:55:31,222 [tomcat-http--23] ERROR com.sas.svcs.authorization.impl.MetadataUserDetailsServiceWrapper -
Unable to fetch metadata roles and capabilities for user 'userid'
com.sas.svcs.authentication.helper.TrustedAuthenticationException:
com.sas.services.user.NonPersonAuthenticationException: Only a Person can be used to authenticate a platform user.
....
2016-03-18 10:55:31,323 [tomcat-http--23] WARN org.springframework.remoting.support.RemoteInvocationTraceInterceptor -
Processing of AutoDiscoveredHttpServiceExporter remote call resulted in fatal exception:
org.springframework.security.core.userdetails.UserDetailsService.loadUserByUsername
org.springframework.security.authentication.InsufficientAuthenticationException:
Unable to create a user context for user: userid
In a Windows environment, SAS Visual Data Builder might display this error:
Submission of generated code to server failed.
ERROR: flow script execution failed. Windows Error Code: 2.
The operation completed successfully. ERROR: One or more flows were not successfully scheduled.
This problem can occur if the following conditions are true:
- An account assigned to a metadata group is being used to run the operating system scheduling server.
- The output table is being saved to the SAS® LASR™ Analytic Server.
Authorization to the SAS LASR Analytic Server requires an individual, external user account. You cannot use a group account for authorization.
Operating System and Release Information
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 6.4 | | 9.4 TS1M1 | |
Linux for x64 | 6.4 | | 9.4 TS1M1 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2016-03-24 10:05:21 |
Date Created: | 2016-03-21 14:53:30 |