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

Last updated on SEPTEMBER 13, 2024

Applies to:

Symptoms

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

In the log see the error message:

[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()

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.