My Oracle Support Banner

Unable to perform HIVE test connection from EDS screen using Simba driver (Doc ID 2598857.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.6 version, Install Issues_OFSS

When attempting to define EDS of HIVE type and perform Test Connection,
the following error occurs.

ERROR
-----------------------

08-10-19 21:06:45 PM] ~ ERROR ~ DIHLOGGER ~ [DataStoreServiceClient][performAction][Simba][HiveJDBCDriver](500151) Error setting/closing session: Open Session Error.
java.sql.SQLException: [Simba][HiveJDBCDriver](500151) Error setting/closing session: Open Session Error.
at com.simba.hiveserver2.hivecommon.api.ExtendedHS2Client.openSession(Unknown Source) ~[HiveJDBC4.jar:?]
at com.simba.hiveserver2.hivecommon.api.HS2Client.(Unknown Source) ~[HiveJDBC4.jar:?]
......
[08-10-19 21:06:45 PM] ~ ERROR ~ DIHLOGGER ~ [DataStoreServiceClient][performAction][Simba][HiveJDBCDriver](500151) Error setting/closing session: Open Session Error.
java.sql.SQLException: [Simba][HiveJDBCDriver](500151) Error setting/closing session: Open Session Error.
at com.simba.hiveserver2.hivecommon.api.ExtendedHS2Client.openSession(Unknown Source) ~[HiveJDBC4.jar:?]
at com.simba.hiveserver2.hivecommon.api.HS2Client.(Unknown Source) ~[HiveJDBC4.jar:?]
.....
org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78, *java.lang.RuntimeException:java.io.IOException: Permission denied:46:0, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:496, *java.io.IOException:Permission denied:49:3, java.io.UnixFileSystem:createFileExclusively:UnixFileSystem.java:-2, java.io.File:createTempFile:File.java:2024, org.apache.hadoop.hive.ql.session.SessionState:createTempFile:SessionState.java:820, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:494], errorCode:0, errorMessage:Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException: Permission denied), serverProtocolVersion:null)
at org.apache.hive.service.cli.thrift.TOpenSessionResp.validate(TOpenSessionResp.java:554) ~[TCLIServiceClient.jar:?]
at org.apache.hive.service.cli.thrift.TOpenSessionResp$TOpenSessionRespStandardScheme.read(TOpenSessionResp.java:652) ~[TCLIServiceClient.jar:?]
at org.apache.hive.service.cli.thrift.TOpenSessionResp$TOpenSessionRespStandardScheme.read(TOpenSessionResp.java:1) ~[TCLIServiceClient.jar:?]
at org.apa



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to define Hive type EDS and perform test connection

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create hive type EDS.

Changes

 

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


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