EPMA Error "Requested Service Not Found" (Doc ID 1478661.1)

Last updated on JULY 28, 2016

Applies to:

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

Symptoms

When opening Enterprise Performance Management Architect (EPMA) library (dimension or application) the following error message is displayed:

Requested Service not Found.

In the Dimension Server log this error message is recorded:

[EPMADIM.Hyperion.DataAccessLayerCore.CommandWrapper] [tid: EPMA Server Startup] [ecid: disabled,0] Exception occurred in the DAL.  Error Message: 'Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. The timeout period elapsed prior to completion of the operation or the server is not responding.'.  SQL command or stored proc:
SELECT i_parent_member_id, i_child_member_id
                            FROM    ds_relationship r1
                            INNER JOIN ds_dimension d ON r1.i_library_id = d.i_library_id AND r1.i_dimension_id = d.i_dimension_id
                            WHERE    
                            r1.i_library_id = @p_LibraryID AND  
                            r1.i_dimension_id = @p_DimensionID AND
                            r1.i_parent_member_id NOT IN  
                            (    SELECT r2.i_child_member_id  
                                FROM  ds_relationship r2  
                                WHERE r1.i_library_id = r2.i_library_id AND r1.i_dimension_id = r2.i_dimension_id AND r2.b_primary = 1) AND
                            r1.i_parent_member_id != d.i_top_member_id
                            UNION
                            SELECT i_parent_member_id, i_child_member_id
                            FROM ds_relationship
                            WHERE i_child_member_id  
                            IN (
                             
                              SELECT r.i_child_member_id
                              FROM ds_relationship r
                              WHERE r.i_library_id = @p_LibraryID AND r.i_dimension_id = @p_DimensionID
                              GROUP BY r.i_child_member_id
                              HAVING SUM(CASE(r.b_primary) WHEN 1 THEN 1 ELSE 0 END) = 0
                            )
Params:
p_LibraryID = 1, p_DimensionID = 270
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

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