Hyperion EPMA Server Service Does Not Start

(Doc ID 1675783.1)

Last updated on JANUARY 30, 2018

Applies to:

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


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#] 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)[[


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