ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: Failed to get username: Unspecified GSS failure: Minor code may provide more information

HenrietteH
Alteryx
Alteryx
Created

Environment Details


  • Alteryx Designer
    • all versions
  • Simba Hive ODBC Driver with DSN configured
  • Hadoop uses Kerberos authentication

User is attempting to connect to Hadoop Hive with Kerberos in Alteryx and getting an error: 
[Simba][Support] (50363): Failed to get username: Routine Error:
Unspecified GSS failure. Minor code may provide more information
Mechanism Info:
Unknown code 0
Major: 851968 Minor: 100001 

or

[Simba][Support] (50361): Integrated security failed to acquire local credentials: Routine Error:
Unspecified GSS failure. Minor code may provide more information
Mechanism Info:
Unknown code 0
Major: 851968 Minor: 100004 



The test button in the ODBC DSN is successful. 



Cause


Alteryx cannot find the username, so the login fails.



Resolution



If the user is using Active Directory Kerberos (Kerberos SSPI): 

Solution A: Check "Use only SSPI" in the DSN

  1. Go to the Windows ODBC Data Source Administrator 
  2. Find the ODBC DSN (Data Source Name) being used in Alteryx
  3. Double click the DSN to open it for editing 
  4. Go to "Advanced Options..." 
  5. Check the "Use only SSPI" checkbox
  6. Restart Alteryx and try connecting again
  7. In some cases this may still not be sufficient for Alteryx to be able to find the Username. In that case proceed to Solution B
idea Skyscrapers


 

Solution B: Check "Use only SSPI" in the Driver Config

  1. Confirm the driver version is 2.6.8. It may need to be upgraded. Reach out to customer support if you need help acquiring an installer for the correct version. 
  2. Browse to the /lib folder in the install directory (typically, this is: C:\Program Files\Simba Hive ODBC Driver\lib)
  3. Double click on the DriverConfiguration64.exe file to open the driver configuration editor
    Note: this edits global settings for all DSNs that use this driver
  4. Go to "Advanced Options..."
  5. Check the "Use only SSPI" checkbox
  6. Restart Alteryx and try connecting again
  7. You may have to restart the machine to make sure the edits are applied 
 
idea Skyscrapers



If the user is using MIT Kerberos: 

Solution C: Set environmental variables

Note: This might require assistance from IT and/or the Hive admin. 
  1. Open the System Environmental Variables: 
    1. Open the Windows System Properties window
    2. Go to the Advanced Tab and select Environmental Variables
  2. In the System variables, create two new variables/confirm these variables are pointing at the correct location: 
    1. KRB5_CONFIG: point this to the location of the main Kerberos configuration file
    2. KRB5CCNAME: default name for the credentials cache file
  3. Reboot the machine to make sure the variables are applied
For more information on the variables, please see the MIT Kerberos documentation on environmental variables