My Oracle Support Banner

ODI 12c J2EE Agent Test Connection to Kerberos Protected Hive at First Successful, but Fails on Subsequent Attempts to Test (Doc ID 2541662.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

The issue is witnessed after successful configuration of the connection for an Oracle Data Integrator (ODI) 12c Java EE Agent to Kerberos protected Hive cluster.

The Java Agent starts fine and tests from ODI Studio. The test to the Hadoop Data Server is successful with no issue.

The test from ODI Studio with the Java Agent to Hive is successful at first as well.

However, after a few minutes upon subsequent tests, the connection fails with the following error:

ODI-1592: Error occurred testing connection to dataserver with agent <AGENT NAME>

Caused By: oracle.odi.core.exception.OdiRuntimeException:
java.sql.SQLException: [FMWGEN][Hive JDBC Driver]A username was not specified and the driver could not establish a connection using Kerberos (type 4) integrated security: No valid credentials provided
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:276)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:121)
  at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
  at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
  at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:836)
  at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:754)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
  at ...

Caused by: java.sql.SQLException: [FMWGEN][Hive JDBC Driver]A username was not specified and the driver could not establish a connection using Kerberos (type 4) integrated security: No valid credentials provided

  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
  at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAd apter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:270)
  ... 53 more

Caused by: java.sql.SQLException: [FMWGEN][Hive JDBC Driver]A username was not specified and the driver could not establish a connection using Kerberos (type 4) integrated security: No valid credentials provided

  at weblogic.jdbc.hivebase.ddcp.b(Unknown Source)
  at weblogic.jdbc.hivebase.ddcp.a(Unknown Source)
  at weblogic.jdbc.hivebase.ddco.b(Unknown Source)
  at weblogic.jdbc.hivebase.ddco.a(Unknown Source)
  at weblogic.jdbc.hive.HiveImplConnection.a(Unknown Source)
  at weblogic.jdbc.hive.HiveImplConnection.b(Unknown Source)
  at weblogic.jdbc.hivebase.BaseConnection.b(Unknown Source)
  at weblogic.jdbc.hivebase.BaseConnection.k(Unknown Source)
  at weblogic.jdbc.hivebase.BaseConnection.b(Unknown Source)
  at weblogic.jdbc.hivebase.BaseConnection.a(Unknown Source)
  at weblogic.jdbc.hivebase.BaseDriver.connect(Unknown Source)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:414)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:387)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:354)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:333)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)

As of note, sometimes restarting the agent allows again for successful connection for a brief time before it throws the same error again.

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
References


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