Hyperion Financial Management (HFM) Error When Opening an Application: "HFM EPMHFM-66054: The System Was Unable To Find The Datasource Process For Application XXX" (Doc ID 1999915.1)

Last updated on AUGUST 29, 2023

Applies to:

Symptoms

After successfully creating an application, the following error occurs when opening the application:

Error: "EPMHFM-66054: The system was unable to find the Datasource process for application XXX"

The following are examples of the errors seen for an application called SIMPLE2:

• Attempting to open the application in Workspace, you receive the following error, "HFM EPMHFM-66054: The system was unable to find the Datasource process for application SIMPLE2."

• In the oracle-epm-fm-hsx-server.log

[2015-04-15T16:31:54.418+04:00] [FM] [WARNING] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 14] [ecid: 0000Kmx44^gBHB85VjDCic1L7Nv6000TFJ,0:4] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: pingDatasource] Unable to invoke ping on XDS management service for the application SIMPLE2 ,

[2015-04-15T16:31:54.418+04:00] [FM] [NOTIFICATION] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 14] [ecid: 0000Kmx44^gBHB85VjDCic1L7Nv6000TFJ,0:4] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: performDataSourceHealthCheckup] DataSource Process status for the application  SIMPLE2 : NOT_LISTENING

[2015-04-15T16:31:54.433+04:00] [FM] [NOTIFICATION] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceProcessManager] [tid: 30] [ecid: 0000Kmx44^gBHB85VjDCic1L7Nv6000TFJ,0:4:15] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceProcessManager] [SRC_METHOD: onProcessFailed] Datasource process for application SIMPLE2 stopped/crashed.
[2015-04-15T16:31:54.433+04:00] [FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.ApplicationManagerDALImpl] [tid: 30] [ecid: 0000Kmx44^gBHB85VjDCic1L7Nv6000TFJ,0:4:15] [SRC_CLASS: oracle.epm.fm.dal.manager.ApplicationManagerDALImpl] [SRC_METHOD: deleteCCLockRecordsForServer]  Table SIMPLE2_CC_LOCKS does not exist
[2015-04-15T16:31:55.447+04:00] [FM] [ERROR] [EPMHFM-66076] [oracle.FM.FMCOMMON.oracle.epm.fm.common.ServiceClientFactory] [tid: 14] [ecid: 0000Kmx44^gBHB85VjDCic1L7Nv6000TFJ,0:4] [SRC_CLASS: oracle.epm.fm.common.ServiceClientFactory] [SRC_METHOD: getClient] Ñåðâåð HQ-EPM-HFM01 íåäîñòóïåí, íå óäàëîñü óñòàíîâèòü ïîäêëþ÷åíèå.[[
org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused: connect
at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
at oracle.epm.fm.common.ServiceClientFactory.getProtocol(ServiceClientFactory.java:171)
at oracle.epm.fm.common.ServiceClientFactory.getClient(ServiceClientFactory.java:71)
at oracle.epm.fm.dslm.DatasourceManagerImpl.pingDatasource(DatasourceManagerImpl.java:1038)
at oracle.epm.fm.dslm.DatasourceManagerImpl.performDataSourceHealthCheckup(DatasourceManagerImpl.java:804)
at oracle.epm.fm.dslm.DatasourceManagerImpl.isDatasourceRunning(DatasourceManagerImpl.java:782)
at oracle.epm.fm.dslm.DatasourceManagerImpl.waitForDSInitialization(DatasourceManagerImpl.java:711)
at oracle.epm.fm.dslm.DatasourceManagerImpl.getDatasourceInfo(DatasourceManagerImpl.java:689)
at oracle.epm.fm.hsxserver.service.HsxServerDelegate.openApplication(HsxServerDelegate.java:117)
at oracle.epm.fm.hsxserver.service.HsxServerImpl.createSession(HsxServerImpl.java:261)
at oracle.epm.fm.hsxserver.service.HsxServerServiceHandler.createSession(HsxServerServiceHandler.java:201)
at oracle.epm.fm.common.service.hsxserver.HsxServerService$Processor$createSession.getResult(HsxServerService.java:3851)
at oracle.epm.fm.common.service.hsxserver.HsxServerService$Processor$createSession.getResult(HsxServerService.java:3835)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
... 18 more

• In the xfm.odl.AppName.log:

[11.1.2.4.000.4847] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 0; MSG = [DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names file.]]

Cause

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