SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64250: SAS® Viya® 3.4 applications return unexpected results when you view or create items

DetailsHotfixAboutRate It

Beginning with SAS Viya 3.4 (19w21), you might experience one or more of the following behaviors when creating or viewing items:

  • Credentials are not saved for a user within the Credentials page.
  • Authorizations are not saved within the Edit Authorization window for a content or data item.
  • The View/Edit Authorization window might show the same user more than once, each with a different case in the Principal column.
  • The View/Edit Authorization window might show a principal with the warning note, "This principal was not found."
  • A user might have more than one Users folder, each with a different case in the name.

These problems occur when the case of the ID that the user provided at logon does not match the case of the user's ID attribute in LDAP. An ID of SASDEMO is considered a different user from sasdemo and SASdemo.

The SASLogon service maintains users' IDs in the SAS® Infrastructure Data Server (Postgres) in the same case that was provided by the user. This value is returned by SASLogon as the "current user" ID in client requests, such as a GET request for credentials belonging to the current user.

When the current user ID is a different case than in LDAP, the request returns no results or results that differ from what is expected. Here is an example of a GET request to the credentials service when the LDAP ID of a user is SASDEMO, but SASLogon has saved the ID as sasdemo.

/credentials/domains/ORAAuth/users/@currentUser
{"errorCode":12302,"message":"The credential for the user \"sasdemo\" in the domain \"ORAAuth\" does not exist.","details":["correlator: cd7bbe21-50e7-4870-8cc7-bed0b79ef8a5","traceId: a072a6d557465957","path: /credentials/domains/ORAAuth/users/@currentUser"],"links":[],"version":2,"httpStatusCode":404}

The SASLogon service adds or updates a user's ID in the SAS Infrastructure Data Server in the following patterns:

  • SAS Viya 3.4 (19w21) (saslogon version 2.16.12): The ID is added to the user's table with the case that was provided during the first logon to SAS Viya. It is not updated upon subsequent logons.
  • SAS Viya 3.4 (19w30) (saslogon version 2.18.10): The ID is added or updated using the case that was provided at logon. When subsequent logons are of a different case, the ID value is updated.

You can determine the version of the SASLogon service using one of these methods:

  • On Linux systems, run the following rpm command from the SAS Viya microservices host machine:

       rpm -q sas-saslogon

    The version number is shown after the service name. Here is an example:

       sas-saslogon-2.16.12-20190328.1553803782918.x86_64
       sas-saslogon-2.18.10-20190702.1562085398319.x86_64

     
  • On Linux or Windows systems, connect to the /SASLogon/apiMeta endpoint. The XML output shows the version like the following:

       "buildVersion":"2.16.12"
       "buildVersion":"2.18.10"

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Verify that the Update Is Installed

To verify that the update is installed, use one of the methods shown above.

To complete this process, make sure that the SASLogon service version shown in the output either matches or is newer than the following:

(for the rpm command method): sas-saslogon-2.18.12-20190829.1567081522176.x86_64

(for the /SASLogon/apiMeta endpoint method) "buildVersion":"2.18.12"

Additional Steps

After you install the update, the case of the ID maintained by SASLogon will match the case of the user's ID attribute in LDAP, regardless of the case used when logging in.

If a user has more than one Users folder and each has a different case in the name, then use SAS® Environment Manager as an Administrator to move SAS content such as folders, files, and reports to the correct User folder. The "correct" folder has the name that matches the casing of the user's ID. Refer to the Promotion within SAS Viya: Instructions section in SAS® Viya® 3.4 Administration / Promotion (Import and Export) for the steps to move content from one folder to another.

If a user's My Credentials page in SAS Environment Manager no longer shows credentials, the user can do one of the following:

  • Recreate the credentials
  • Contact SAS Technical Support to coordinate the specific steps for their environment

Additional Assistance

If you need additional assistance, contact SAS Technical Support.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS ViyaMicrosoft® Windows® for x643.43.5Viya
Microsoft Windows 8 Enterprise 32-bit3.4
Microsoft Windows 8 Enterprise x643.43.5Viya
Microsoft Windows 8 Pro 32-bit3.4
Microsoft Windows 8 Pro x643.43.5Viya
Microsoft Windows 8.1 Enterprise 32-bit3.4
Microsoft Windows 8.1 Enterprise x643.43.5Viya
Microsoft Windows 8.1 Pro 32-bit3.4
Microsoft Windows 8.1 Pro x643.43.5Viya
Microsoft Windows 103.43.5Viya
Microsoft Windows 95/983.4
Microsoft Windows 2000 Advanced Server3.4
Microsoft Windows 2000 Datacenter Server3.4
Microsoft Windows 2000 Server3.4
Microsoft Windows 2000 Professional3.4
Microsoft Windows NT Workstation3.4
Microsoft Windows Server 2003 Datacenter Edition3.4
Microsoft Windows Server 2003 Enterprise Edition3.4
Microsoft Windows Server 2003 Standard Edition3.4
Microsoft Windows Server 2003 for x643.43.5Viya
Microsoft Windows Server 20083.4
Microsoft Windows Server 2008 R23.43.5Viya
Microsoft Windows Server 2008 for x643.43.5Viya
Microsoft Windows Server 2012 Datacenter3.43.5Viya
Microsoft Windows Server 2012 R2 Datacenter3.43.5Viya
Microsoft Windows Server 2012 R2 Std3.43.5Viya
Microsoft Windows Server 2012 Std3.43.5Viya
Microsoft Windows Server 20163.43.5Viya
Microsoft Windows Server 20193.43.5Viya
Microsoft Windows XP Professional3.4
Windows 7 Enterprise 32 bit3.4
Windows 7 Enterprise x643.43.5Viya
Windows 7 Home Premium 32 bit3.4
Windows 7 Home Premium x643.43.5Viya
Windows 7 Professional 32 bit3.4
Windows 7 Professional x643.43.5Viya
Windows 7 Ultimate 32 bit3.4
Windows 7 Ultimate x643.43.5Viya
Windows Millennium Edition (Me)3.4
Windows Vista3.4
Windows Vista for x643.43.5Viya
Linux for x643.43.5Viya
* 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.