ORA-03114:not connected to ORACLE When trying to access EPMA Dimension Library (Doc ID 2000526.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.3.501 and later
Information in this document applies to any platform.

Symptoms

 This issue would be intermittent. We could find the below from the event viewer

 

[12] FATAL ORA-03114: not connected to ORACLE
  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
  at Oracle.DataAccess.Client.OracleTransaction.Rollback()
  at Hyperion.DataAccessLayerCore.DatabaseContext.Rollback()
  at Hyperion.DataAccessLayerCore.DALDatasetCommand.get_Reader()
  at Hyperion.DataAccessLayerCore.DALDatasetCommand.Dispose(Boolean disposing)
  at Hyperion.DataAccessLayerCore.SchemaCommand`1.Dispose(Boolean disposing)
  at Hyperion.DataAccessLayerCore.SchemaCommand`1.Dispose()
  at Hyperion.DataAccessLayerCore.GenericDAO.Select[T](Action`1 callback, SetParamsEvent`1 onSetParams)
  at Hyperion.SessionManager.DAO.SessionManagerDAO.FindSession(String sessionID)
  at Hyperion.DimensionServer.SessionManager.SessionStoreRdbms.GetSession(Guid sessionID)
  at Hyperion.DimensionServer.SessionManager.SessionManager.GetSession(Guid sessionId)
  at Hyperion.DimensionServer.SecurityManager.ValidateSession(Guid sessionID)
  at Hyperion.DimensionServer.Global.HandleThreadContext(Guid sessionID, ThreadContextDelegate method)
  at Hyperion.DimensionServer.BaseProxy.HandleAPICall(Guid sessionID, ThreadContextDelegate method)Oracle.DataAccess.Client.OracleException ORA-03114: not connected to ORACLE    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

Changes

 No changes . This could be new or old installation

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms