Hyperion EPMA Server Service Does Not Start (Doc ID 1675783.1)

Last updated on AUGUST 29, 2016

Applies to:

Hyperion Financial Management - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms

Enterprise Performance Management Architect (EPMA) service does not start. The following error message is recorded in the Dimension server log:

[EPMADIM] [INTERNAL_ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.DataAccessLayerCore.CommandWrapper] [tid: EPMA Server Startup] [ecid: disabled,0] Exception occurred in the DAL.  Error Message: 'ORA-00904: "I_ORDER": invalid identifier'.  SQL command or stored proc:
                           SELECT i_library_id, i_dimension_id, i_view_id, i_view_filter_id, i_parent_member_id, i_top_member_id, i_order
                           FROM DS_View_Filter_Member
                           WHERE i_library_id = :p_LibraryID
                           ORDER BY i_view_id ASC, i_view_filter_id ASC, i_order ASC


In EPMA log the following error is recorded:

[APP: EPMAWEBTIER#11.1.2.0] exception: <BpmResponse type='error'><actor>none</actor><code>com.hyperion.awb.web.common.DimensionServiceException</code><desc>Requested Service not found</desc><trace>com.hyperion.awb.web.common.BaseService.openSession(Unknown Source)[[

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