UNABLE TO CONNECT - ODBC

[YelloBlack]

"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

[Anonymous]

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

[YelloBlack]

Hi @Anonymous,

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

[Anonymous]

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

[YelloBlack]

Hi @Anonymous

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

[Anonymous]

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

[YelloBlack]

Hi @Anonymous

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.

[YelloBlack · Accepted solution]

Yay!

I am able to connect now the issue was with version of powerBi .  I downloaded 64bit and works well.

Thanks

YB

[edejes2]

Hello, 

I am having same issues can you please provided me with some guidance. 

Regards!

Erich Dejesus

[YelloBlack]

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

[edejes2]

 This is the error message I am getting. 

I am using the latest PBI Desktop 64bit, Hortonworks Hive OBDC 64bit.

Thank you!

[YelloBlack]

Hi @edejes2 

are you able to succesfully test your ODBC connection?

YB

[edejes2]

Yes. 

Thank you!