Forum Stats

  • 3,855,210 Users
  • 2,264,475 Discussions
  • 7,905,930 Comments

Discussions

EPMA Server Error & Not able to open work On EPMA.

661891
661891 Member Posts: 91
edited Sep 7, 2011 9:45AM in EPM System Infrastructure
Hi All,

After configuring the EPMA in 11.1.2.1.0, i got succeed the all necessary step to complete. But after that i could not able to start the EPMA server. I went through the Log file and EventViewer as below.

Appriciate your help ..

[Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Oracle.DataAccess.Client.OracleException ORA-00942: table or view does not exist at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)

[EPMA Server Startup] ERROR Exception occurred in the DAL. Error Message: 'ORA-00942: table or view does not exist'. SQL command or stored proc: SELECT Schema_Version FROM Schema_Version
Oracle.DataAccess.Client.OracleException ORA-00942: table or view does not exist at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Hyperion.DataAccessLayerCore.DALDatasetCommand.get_Reader()


Thank,Rao

Answers

This discussion has been closed.