Error Connecting to Hyperion Financial Management (HFM) Application: "EPMHFM-66054: The system was unable to find the Datasource process for application" "EPMHFM-69052: The system was unable to open the application" (Doc ID 2457588.1)

Last updated on APRIL 13, 2022

Applies to:

Symptoms

Intermittent error opening HFM application from Workspace, Financial Reports, FDMEE...

Pop up error may contain the following:

• EPMHFM-66054: The system was unable to find the Datasource process for application
• EPMHFM-69052: The system was unable to open the application
• EPMHFM-66076: Server MYSERVER is unavailable, connection could not be established.

On HFM Web server, log oracle-epm-fm.log may contain error like:

[HFMWeb0] [ERROR] [EPMHFM-66030] [oracle.FM.FMCOMMON.oracle.epm.fm.common.exception.ExceptionHelper] [tid: 1848] [userId: ] [ecid: ] [APP: FMADFWEB#11.1.2.0] [SRC_CLASS: oracle.epm.fm.common.exception.ExceptionHelper] [SRC_METHOD: handleException] An unexpected communication error has occurred.[[org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

Errors seen in FDMEE's ODI Agent log (<DOCUMENT 2099787.1>) like: 

ERROR [AIF]: oracle.epm.fm.common.exception.HFMException: EPMHFM-66076: Server MYSERVER is unavailable, connection could not be established.

Errors found in Windows System Event log:

Source:  Tcpip   Event ID: 4227

TCP/IP failed to establish an outgoing connection because the selected local endpoint was recently used to connect to the same remote endpoint. This error typically occurs when outgoing connections are opened and closed at a high rate, causing all available local ports to be used and forcing TCP/IP to reuse a local port for an outgoing connection. To minimize the risk of data corruption, the TCP/IP standard requires a minimum time period to elapse between successive connections from a given local endpoint to a given remote endpoint.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.