SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 57907: SAS® Visual Data Builder scheduling might fail with "ERROR: Unauthorized: Check username/password"

DetailsAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual AnalyticsMicrosoft® Windows® for x646.49.4 TS1M1
Linux for x646.49.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.