My Oracle Support Banner

OAC-CM : Unable to create connection to Hive Datasources (Doc ID 2657876.1)

Last updated on APRIL 20, 2020

Applies to:

Oracle Analytics Cloud - Classic - Version 105.5.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading OAC instance to the latest version 105.5.0-308 the connectivity between OAC and Hive database hosted in Oracle Big data cluster stopped working for normal Kerberos users.

So you get below error while trying to establish a connection via Hive Datasource

Failed with the following errors:

Error message while trying to save the connection in DV:

Failed to save the connection.
Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 16028] ODBC error state: 08001 code: 0 message: [Oracle DataDirect][ODBC Apache Hive Wire Protocol driver]Client unable to establish connection.GSS initiate failed. Action: Invalid Host or Port details specified

Errors seen in obis1-diagnostic.log:

 [nQSError: 16028] ODBC error state: 08001 code: 0 message: [Oracle DataDirect][ODBC Apache Hive Wire Protocol driver]Client unable to establish connection.GSS initiate failed. [[
 : server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcConnection.cpp; line: 1102

 

Changes

 Upgraded to OAC 105.5.0-308 from the previous version

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.