Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
"UNABLE TO CONNECT"
Encountered an error while trying to connect to ODBC
Details: "ODBC: ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Internal credentials cache error).
ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Internal credentials cache error)."
I am able to sucssefully test the connection from Hortonworks Hive ODBC Driver DSN Setup
Solved! Go to Solution.
Yay!
I am able to connect now the issue was with version of powerBi . I downloaded 64bit and works well.
Thanks
YB
Hi @YelloBlack,
Firstly, ensure that you download the latest version of Hortonworks Hive ODBC Driver.
Secondly, in the DSN setup window, enable “Use only SSPI” under Advanced Options, then check if the error still occurs.
Thirdly, follow the steps in this blog to use “User Name” Mechanism to connect to Hive and check if it is successful.
Thanks,
Lydia Zhang
Hi @v-yuezhe-msft,
Thanks for your response.
I am using version Hortonworks Hive ODBC Driver 2.5 Version.
For point two i get an error
FAILED!
[Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: The specified target is unknown or unreachable
For point three i get an error.
[Hortonworks][ThriftExtension] (2) Error occured during authentication.
Can i not connect using "Kerberos" instead of "User Name" Athentication Mechanism ?
Regards
YB
Hi @YelloBlack,
You can use Kerberos authentication. The first error is related to your Kerberos settings, please follow the instructions in this article to configure Kerberos authentication.
Thanks,
Lydia Zhang
Successfully connected to Hortonworks Hive ODBC Driver DSN Setup (MIT Kerberos) with message
SUCCESS!
Successfully connected to data source!
ODBC Version: 03.80
Driver Version: 2.1.7.1010
Bitness: 32-bit
Locale: en_US
When using the same System DSN to connect on powerBI i get following error -
Unable to connect
We enountered an error while trying to connect.
Details: "ODBC: ERROR [HY000] [DSI] The error message HardyHiveError could not be found in the en-US locale. Check that C:\Program Files (x86)\Hortonworks Hive ODBC Driver\ErrorMessages\en-US\HiveODBCMessages.xml exists.
ERROR [HY000] [DSI] The error message HardyHiveError could not be found in the en-US locale. Check that C:\Program Files (x86)\Hortonworks Hive ODBC Driver\ErrorMessages\en-US\HiveODBCMessages.xml exists."
I am using 32bit powerBi and hortonworks hive driver setup.
Regards,
YB
Hi @YelloBlack,
Please follow the instructions in the blog below to troubleshoot the above error message. The configuration file in your scenario is hortonworks.hiveodbc.ini .
https://archive.sap.com/discussions/message/15565579?tstart=0#15565579
Thanks,
Lydia Zhang
I am back to intial error of -
" Details: "ODBC: ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Internal credentials cache error).
ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Internal credentials cache error)."
My machine is 64bit windows 7 Enterprise
I have both 64bit and 32bit Hortonworks Hive ODBC Drivers(latest version)
I have PowerBi 32bit
Should i get 64bit powerbi? could that be the issue?
Thanks for all the support.
Yay!
I am able to connect now the issue was with version of powerBi . I downloaded 64bit and works well.
Thanks
YB
Hello,
I am having same issues can you please provided me with some guidance.
Regards!
Erich Dejesus
Hi @edejes2,
Could you please provide further details to your issue. Like what version of PowerBI are you using, what is the error message or any other details that you might think would be useful.
I will try to help. Thanks!
YB
This is the error message I am getting.
I am using the latest PBI Desktop 64bit, Hortonworks Hive OBDC 64bit.
Thank you!
Yes.
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.