ODI Execution Intermittently Hangs With "ORA-08103: object no longer exists" Error On Oracle 12c Database (Doc ID 2208070.1)

Last updated on AUGUST 23, 2017

Applies to:

Symptoms

Oracle Data Integrator (ODI) executions intermittently fail when the ODI Repositories are hosted on an Oracle 12c database, and the following error is observed in the ODI log file:

[2016-10-21T07:28:44.373-06:00] [odi_server1] [ERROR] [ODI-1219] [] [tid: 830560] [userId: <anonymous>] [ecid: 0000LVbRV0G3R9C5vFCCyX1O1_of000RtA,0] [APP: oraclediagent] Session preparation failure: database error while connecting to work repository MYWORKREPO.[[
java.sql.SQLException: ORA-08103: object no longer exists
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
  at sun.reflect.GeneratedMethodAccessor1118.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
  at com.sun.proxy.$Proxy155.executeQuery(Unknown Source)
  at sun.reflect.GeneratedMethodAccessor1118.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at oracle.odi.runtime.agent.utils.AgentDataSourceCreatorConfig$StatementInvocationHandler.doExecution(AgentDataSourceCreatorConfig.java:1156)
  at oracle.odi.runtime.agent.utils.AgentDataSourceCreatorConfig$StatementInvocationHandler.doExecution(AgentDataSourceCreatorConfig.java:1126)
  at oracle.odi.runtime.agent.utils.AgentDataSourceCreatorConfig$StatementInvocationHandler.invokeMethodWithRetry(AgentDataSourceCreatorConfig.java:1088)
  at oracle.odi.runtime.agent.utils.AgentDataSourceCreatorConfig$StatementInvocationHandler.invoke(AgentDataSourceCreatorConfig.java:1074)
  at com.sun.proxy.$Proxy156.executeQuery(Unknown Source)
  at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:645)
  at com.sunopsis.dwg.dbobj.SnpAgent.getRunningSessions(SnpAgent.java:191)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.enqueueOrAcquireSessionForExecution(TaskExecutorAgentRequestProcessor.java:144)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$9(StartScenRequestProcessor.java:1)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:563)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)
  at java.lang.Thread.run(Thread.java:745) ]]

Cause