Hyperion Planning: Oracle Hyperion EPMA Server (foundation1) Service on Local Computer Started and then Stopped.

(Doc ID 2344132.1)

Last updated on JANUARY 05, 2018

Applies to:

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

Symptoms

On : 11.1.2.4.000 version, Product Usage

Oracle Hyperion EPMA Server (foundation1) service on Local Computer started and then stopped.
 

ERROR
-----------------------
[EPMA DimensionServer Startup] ERROR Exception occurred in the DAL. Error Message: 'ORA-06550: line 1, column 7:
PLS-00201: identifier 'USP_GETNEXTSEQUENCE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'. SQL command or stored proc: usp_GetNextSequence
Params:
p_v_c_key_field = i_schema_history_id, p_v_i_reserve = 1, p_v_result = -1
Oracle.DataAccess.Client.OracleException ORA-06550: line 1, column 7:
PLS-00201: identifier 'USP_GETNEXTSEQUENCE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Hyperion.DataAccessLayerCore.DALCommandStoredProcedure.Execute()


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Dimension Server is not starting up

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