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:

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)

Changes

Cause

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