My Oracle Support Banner

When Using Non_Default Port 9091, Hyperion Financial Management (HFM) Application Throws Error: "EPMHFM-69451 No Server Specified For Datasource Process For Application" (Doc ID 2736937.1)

Last updated on MARCH 11, 2021

Applies to:

Hyperion Financial Management - Version 11.2.3.0.000 to 11.2.3.0.000 [Release 11.2]
Hyperion Financial Management - Version 11.1.2.4.209 to 11.1.2.4.209 [Release 11.1]
Information in this document applies to any platform.

Symptoms

HFM application servers are configured to use a port other than default of 9091/9092. HFM's oracle-epm-fm-hsx-server.log will contain this error when application startup is attempted:

[FM] [WARNING] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] An error occurred retrieving property isSSL from EPM registry, using default value  :false.
[FM] [NOTIFICATION] [EPMHFM-65983] [oracle.FM.HSX.SERVER.oracle.epm.fm.common.HsxServerConfig] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.common.HsxServerConfig] [SRC_METHOD: load] The path to the configuration file location is: <DRIVE>:\Oracle\Middleware\user_projects\epmsystem1/config/hfm/configom.properties.
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init]  isSSLEnabled :false
 [FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init]  Base Port : <NOT PORT 9091>
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init]  SSL Port : <NOT PORT 9092>
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init]  Thread Pool Size :70
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.common.BaseSeviceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.common.BaseSeviceManager] [SRC_METHOD: isServerPortAvailable]  Is Port :<NOT PORT 9091>is available ? true
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Database type : <Database Type>
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.MaximumIdleConnections.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.TimeBetweenEvictionThreadRunsMillis.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.SoftMinEvictableIdleTimeMillis.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.NumConnectionTestsPerEvictionRun.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.NumMinIdleConnections.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: <init>] This Server Name :  <SERVERNAME>
[FM] [WARNING] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: initializeRegistryData] An error occurred retrieving property port from EPM registry, using default value  :9091.

Changes

Either this is a new installation or some change has been applied to the existing deployment to use ports other than 9091/9092.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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